Forum Discussion
Excel Conditional Formatting
Is there a way for a conditional formatting rule to contain a general condition. What I want to do is: if 1 cell contains text or a date another cell will state "Yes". E.g if A1 = 04/07/2023 ...
=A1<>""
Write Yes in cell A2, font color white. Conditional formatting paste this formula into New Rule --> Use a formula to determine which cells to format.
Font color automatic or black (depending on your preference).
If in A1 date appears Yes not in A2 (becomes white), if date or not blank appears Yes (becomes black).
See included sample file.