Thread: Any way to test whether rows are empty or contain the word Pass ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rCube rCube is offline
external usenet poster
  
Posts: 1
Default Any way to test whether rows are empty or contain the word Pass ?
Excel 2003
c d e f g h
3 pass pass pass
4
5
6 pass pass
7
8 pass pass

If ranges c3:h3 to range c55:h55 have rows like 4 ,5 and 7 that are blank,
then shade them in light blue
Reply With QuoteReply With Quote