Conditional Formating cells in table referencing adjacent cell containing text

[SHANE78]

I am a little stuck on with conditional formating. I have a table table that i'd like to format. Specifically a row of cells (E14:K14) that i'd like to highlight if cell (D14) is listed in a range of cells on a seperate tab (C12:C43). Do i need to do an if statement with a match statement? I am not sure how to proceed. Thanks in advance for the assistance. Oh, and the cell values are all text.

 

[anand_babu123]

Hi

You can do this by conditional formatting.

1. Select D14 to K14 , Go to conditional formatting (Alt,o,d)

2. Click New rule

3. Click Use a formula to determine which cell to format

4. Enter =COUNTIF($C$12:$C$44,$D15)>0

5 Format some color and click OK.

Thanks
4.

 

[SHANE78]

Thank you anand_babu123. However I'm still having an issue with blank cells in the cell range. For example what if there are blanks in cells with the c12:c44 range? When I input the formula for CF and I leave cell d14 blank, cells e14:k14 are grey (per my CF). I would have thought the >0 would take care of that. Any suggestions? Thanks

 

[anand_babu123]

Hi ,

Kindly try this formula in conditional formatting.

=COUNTIF($C$12:$C$44,$D15)>0