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
|