Conditional Formatting with Data Validation

[esther148]

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.

[#2]

@esther148 

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.