rutgermons
asked on
FORMATTING ENTIRE COLUMN WITH COLOUR BASED ON date
Folks
How do I conditional format my entire column B2 : B10000 if B1's day value matches todays date??
How do I conditional format my entire column B2 : B10000 if B1's day value matches todays date??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@rorya Thanks
I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015
I think you mean:
=INT($B$1)=TODAY()
since TODAY only returns a date, not time.