How to force CF second condition evaluation in Excel 2002?
How to force CF second condition evaluation in Excel 2002?
Try this as your rule...
=WEEKDAY(TODAY(),2)=4
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The desired effect is that every cell in column A that contain a date whose day is THURSDAY to get the background color (with black letters) EXCEPT for today's Thursday that should have BOTH the background color AND red letters.
Figured it out.
aahh OK, left out the TODAY() test, but as long as you got it resolved, good job
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks