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...
Select the range where you want to apply conditional formatting:
Select conditional formatting--> new rule
choose :
Enter the formula: =AND(A2<>"",B2="")
choose your format and click OK.
this will apply conditional formatting to complete selected range, formula that you write should be valid for first cell of the selection, it will automatically dragged down for rest of the selection.
