Forum Discussion
Conditional Formatting with Data Validation
Hello, I am trying to have a cell be red if other criteria is met on other cells. For example, if A2=Value, B2= Value, and C2 is blank, I would like to have C2 turn red. A2,B2, and C2 all have a...
First, delete existing rules for column C (if any).
Select the range in column C that you want to format, for example C2:C100. The first cell in the range (C2 in this example) should be the active cell in the selection.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND($A2="value1",$B2="value2",$C2="")
Click Format...
Activate the Fill tab.
Select red.
Click OK, then click OK again.