View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Conditional Format (exclude 0)

Excel2003 ... Range A6:G6 contains Formula's

Cell A6 contains a Name (returned by formula)
Range B6:G6 contains values 0 to 7 (returned by formula & may repeat)

I wish to set conditional formatting in Cell A6

Condition = when value in Range B6:G6 is =1 & <5.

Thanks ... Kha