LinkBack URL
About LinkBacks
Can someone please help!
Im trying to use conditional formating to highlight rows on a sheet if a date in colunm E is earlier than todays date.
And then if any date is entred into colunm H the row is un-highlighted?
Can someone please help!
Im trying to use conditional formating to highlight rows on a sheet if a date in colunm E is earlier than todays date.
And then if any date is entred into colunm H the row is un-highlighted?
Last edited by snoopy1461; 01-17-2011 at 10:37 AM.
The CF formula for the first row (row2) would be:
=AND($H2="", $E2>0, $E2<TODAY())
Last edited by JBeaucaire; 01-14-2011 at 12:05 PM. Reason: added a missing paren.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for that,
But it is bring up a error message, 'Your formula is missing a parenthesis--) or ('
So I added on at the end... try that.
I did try that before but didnt work and came up with 'The formula you type contains an error'. Is there anything else that i can do?
Sorry, guess I was asleep at the wheel. CF formulas are TRUE/FALSE constructs, the IF at the beginning is not needed.
=AND($H2="", $E2>0, $E2<TODAY())
Thanks a lot, that's just what i was looking for.
Thanks again for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks