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.