View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Wojo Wojo is offline
external usenet poster
 
Posts: 4
Default Conditional Formatting to a RANGE of cells

Thanks I got it.
I had it right but forgot the = sign.

"cm" wrote in message
...
select a6 thru g6, select 'conditional formating' and under Formula is:

=$G$6$D$6


"Wojo" wrote:

Sorry for the double post.
My original post ended up in the middle of an old thread because of the
same
subject line so I reposted.

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)