View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Odyblue Odyblue is offline
external usenet poster
 
Posts: 1
Default conditional formatting

I am trying to add two conditions to a cell using the formula bar in
conditional formating.
1. If cell A1 is blank, then B2 is blank and grey
2. If A2 has a date entry between 1/12/06 and 31/01/07, then A2 should turn
white (no fill) and allow and entry.

Is this too ambitious?