Hi, I have a tricky one... I'll try to explain it properly.
I have a calendar in excel, I created a formula for today`s date which put a red border around the date.
I also have a formula for holidays and those have a gray filling.
What I am trying to do, if find a formula that if TODAY is a holiday, that the cell will have a red border AND a gray filling.
Can someone help me?
Thanks
ps I have excel 2007
Bookmarks