Conditional Formatting

[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)

 

[Bob I]

Yes, select the block of cells before clicking Conditional formatting.

 

[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

 

[cm]

select a6 thru g6, select 'conditional formating' and under Formula is:

=$G$6>$D$6

 

[Wojo]

Oops got it. I forgot the = sign
Thanks all