View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default conditional format

On Fri, 2 Dec 2005 09:44:46 +0000 (UTC), "TC"
wrote:

Hi - wonder if someone can help me with this one

What would be the conditional format for - if current month = date in cell
A1 then apply format.

i.e. date in cell A1 is dd/mm/yyyy, and I want format to apply for whole
month.

Many thanks


=MONTH(A1)=MONTH(TODAY())


--ron