Thread: If any cell in named range = 8 then shade named range
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
  
Posts: 770
Default If any cell in named range = 8 then shade named range
JJ,

Use Format -- Conditional Formatting in Excel. Highlight Block_Three and
enter this formula in the dialog:

=COUNTIF(Block_Three,8)

Then choose yellow as the format.

hth,

Doug

"JJ" wrote in message
...
How would I do this please?

If any one of the cells in the range("Block_Three") = 8 then shade the
range("Block_Three") yellow.





Reply With QuoteReply With Quote