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

=$G$6$D$6

"Wojo" wrote:

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 (G6D6)