Highlight date

[charliew]

I have a holiday tracker calendar and it uses macros and formulas to calculate days and dates etc.
I have this code:

=IF(AND((COLUMN()-1)>31*($A$3-1),MONTH(DATE($A$2+INT(($A$3+$A$1)/12),IF((INT((COLUMN()-1)/31.001)+$A$1)>12,(INT((COLUMN()-1)/31.001)+$A$1-12),INT((COLUMN()-1)/31.001)+$A$1),ROUNDUP(MOD(COLUMN()-1,31.001),0)))=ROUNDUP(MOD($A$1+$A$3-1,12.01),0)),ROUNDUP(MOD(COLUMN()-1,31.001),0),"")

Can i add something in there to highlight it when the date is today?

cheers

 

[arthurbr]

Try Conditional formatting

 

[charliew]

conditional formatting won't work... i wouldn't have wasted your time if it had done!

 

[arthurbr]

Don't know how to highlight with a formula. Sorry