View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default How do I use cond format formula to set cell text and color?

What if you change formula in B1's Formula Is to =A1 =""
Then, when A1 is blank B1 will adopt the yellow fill and red font
color.
Ken Johnson