color for last day of each month
Format - Conditional Formatting
I'm trying formula is
=EOMONTH(A1,0)=A1
and I think it should work. I'm getting an error "You may not use
references to other worksheets or workbooks for Conditional Formatting
criteria". Maybe someone else can assist.
"Steved" wrote in message
...
Hello from Steved
I have an 12 month excel calendar
I would like to have the last day of each month have a light yellow.
If this is possible how.
Thankyou.
|