Conditional Formatting

W

Wojo

Hi all
I am looking for a way to highlight a block of cells based on the values of
2 of the cells.

Basically I want to be able to highlight A6 through G6 if (G6>D6)
 
N

NBVC

Select A6:G6 and go to Format|Coditional Formatting

Select Formula Is from the 1st dropdown menu

Enter formula: =$G6>$D6

Click Format and choose colour from Pattern tab

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com
 
W

Wojo

Tried that - doesn't work. I tried highlighting the range and entering the
code:
$G$6>$C$6 and had the highlight set to red but it didn't highlight anything
 
Top