Thread: Changing one cell colour by inserting date in another cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Changing one cell colour by inserting date in another cell

Hi,

Use conditionnal formatting in B4
Formula Is and enter formula =MATCH(date(2006,9,1),$A4,0)
and then select Format and Pattern which you want ...

HTH
Cheers
Carim

Reply With QuoteReply With Quote