View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
shapper shapper is offline
external usenet poster
 
Posts: 22
Default Change Cell Background

On Dec 8, 1:54*pm, Ixtreme wrote:
On 8 dec, 14:33, Ixtreme wrote:

Miguel


You should use conditional formatting to do that.


Something like:
=A1NOW() * --- Red
and
=AND(MONTH(A1) = MONTH(NOW()), YEAR(A1) = YEAR(NOW())) * * *------
Orange


I am using Excel 2007.