Conditional Formatting if value is from Formula

Hi, this question is inspired on thread

Use Value in Column B if Exists

Say column A has light pink background.
Is it possible to conditionally format column B as:

  • Bi will have same light pink background if cell value =Ai (value from Formula)
    or
  • light green background if hard inserted (no Formula).

?
Tried Condition > Formula = Ai but it didn’t work.
Thanks in advance.

https://ask.libreoffice.org/uploads/short-url/dIKc4GBD4rs0xP3WJCwAr68t3Yc.ods

1 Like

Ah! Formula is… Bi=Ai
Didn’t think of that!
Another thing it was confusing to me is on
Apply Style: font text box shows example as “underscoresA7underscores”
(not rendering here); with correct (light pink) background.
But at cells text shows up ok (no underscores).
Thank you very much.