Thread: If any cell in named range = 8 then shade named range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JJ[_8_] JJ[_8_] is offline
external usenet poster
  
Posts: 6
Default If any cell in named range = 8 then shade named range
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