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 list range for the Data Validation.
For the conditional formatting, I have only put the range to apply to as column C. The conditional formatting is not turning cells red as needed. I am not sure what the issue is. Thank you for the help in advance.
1 Reply
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.
