Excel help please

SexyGreyFox

SexyGreyFox

SexyGreyFox

Man of Honour
Joined
29 Mar 2003
Posts
57,778
Location
Stoke on Trent
I want to conditional format a cell in Excel 2007.

Cell A1 has got a date in it and I've conditional formatted it to turn red if it goes past todays date so the formula is =today()

When I type a date into cell B1 I want A1 to turn back to white.

How do I do it please?

Thanks
 
Change the Conditional Formatting to be 'Formula Is', then:

=AND(A1>=TODAY(), B1<>"")

that will do what you want as soon as you type anything into B1. If you require it to only work when a date is typed into B1, then you should be able to adjust the formula slightly.
 
div0 said:
Change the Conditional Formatting to be 'Formula Is', then:

=AND(A1>=TODAY(), B1<>"")

that will do what you want as soon as you type anything into B1. If you require it to only work when a date is typed into B1, then you should be able to adjust the formula slightly.
Click to expand...

I'm being a dick.
I can't find 'Formula is' :)
 
That's because they completely changed the way conditional formatting is accessed in the 2007 version, it's far simpler in 2003 and previous. I have 2007 at home so can't check how to get to "Formula is" till then. I know I have done it because I've done it on a spreadsheet at home. If you have the time, the answer is in here somewhere http://msdn.microsoft.com/en-us/library/bb286672(v=office.11).aspx

Just to clarify the excellent formula div0 provided, I read you requirement as needing the cell to go red when the date in there has been and gone, in which case div0's formula needs to be:

=AND(A1<TODAY(), B1<>"")
 
Thanks lads.

Office 2007 is causing me a lot of problems at work and they won't downgrade me back to 2003.
I was on Office 2010 but that was even worse.
 
Got there in the end.
Thanks for the help.

excel1.jpg
 
You must log in or register to reply here.
Back
Top Bottom