Excel conditional formatting - applying rule for individual cells to multiple cell block

Hi Guys,

I'm a bit stuck with a spreadsheet. So I have a block of cells with a yes/no drop down bar. I'm able to conditionally format each cell so that if it says yes, the colour changes...however, I can't find a quick way of doing this for a whole block of cells, other than to individually enter the conditional formatting for each cell.

So to clarify, I want each individual cell in the range D2:I21 to turn green if the value is "YES"

Help please!

Originally Posted by Pepe Le Mokko

Apply following CF to $D$2:$I$21 :

Formula:

Please Login or Register  to view this content.

Format as required

Fantastic, I never would have solved it, thank you!