Forum Discussion
Conditional formatting based on multiple cell formulas
Hello, when a user enter a value in the "Applicable" column in the table below, the cell "Confirmed on" changed color. This is meant to remind them they need to enter a date. I use Conditional Format...
First priority rule for conditional formatting:
=($A9<>"")*($B9<>"")
Second priority rule for conditional formatting:
=$A9<>""
These are the rules for conditional formatting in my example. The rules are in order of their priority in the manager for conditional formatting.
=$B$9:$B$20
The format is applied to this range in my example.
