Excel Formula Help Conditional Formatting - If A2 TODAY and B2 Y turn A2 Green If B2 N turn A2 RED

Question

To highlight a Green or Red outcome, a formula based on two formulas with specific circumstances is all that is needed. Based on the TODAY(), it will either turn A2 Green or Red depending on whether B2 is Y or N.

Answer 1

Create a conditional format rule on A2 which says:

=AND(A2=TODAY(),B2="Y")

This will be true if both A2 equals today and B2 equals "Y." Conditional formatting rules take effect when they contain the word TRUE. Make Green the highlighted colour in this regulation. Put the normal highlighting in red, and if the conditional format is applicable, the red will take precedence.