View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Conditional Formatting

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

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)