View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Oddcarout Oddcarout is offline
external usenet poster
 
Posts: 6
Default Change the color of a cell or text with an if statement

I am using

=$B$1-7<F6<$B$1 (yellow) but it is not working.
I also have:
=F6<$B$1 that is working (red)