# Formula to check if date is greater than or equal to current date

1. ## Formula to check if date is greater than or equal to current date

I'm doing a conditional format for some of my cells. The issue I'm running into is I can't seem to create a formula excel can use to format dates greater than the current date >TODAY() is not working for me. The whole formula needs to see if both I3=0 and >TODAY() then format the entire row. Kinda struggling with this one. Any help is greatly appreciated.  Register To Reply

2. ## Re: Formula to check if date is greater than or equal to current date ``Please Login or Register  to view this content.``
Where [your cell] is the cell you want the formatting applied to.

Cheers,  Register To Reply

3. ## Re: Formula to check if date is greater than or equal to current date Originally Posted by Pyrex238 I'm doing a conditional format for some of my cells. The issue I'm running into is I can't seem to create a formula excel can use to format dates greater than the current date >TODAY() is not working for me. The whole formula needs to see if both I3=0 and >TODAY() then format the entire row. Kinda struggling with this one. Any help is greatly appreciated.
can I3 be a date and a0? don't think so, where will the zero be and will I3 be a date?  Register To Reply

4. ## Re: Formula to check if date is greater than or equal to current date

You don't say where the date is that you are comparing to today. Let's assume in column A. Okay, assuming your data range is A3:J500, select your range, then go to conditional formatting > new rule > use formula

=AND(\$I3=0, \$A3>TODAY()) and format appropriately.
Just to be clear, if the value in column A is greater than todays date and I = 0, then the cell will change formatting.
Does that work for you?  Register To Reply

5. ## Re: Formula to check if date is greater than or equal to current date

As ConneXionLost said, highlight the row then go into C/F, new rule and
apply this formula. I've put your ref to 0 im H3 =AND(\$I3>TODAY(),\$H3=0) only thing wrong with this is CF will see an empty cell as being the same as 0. If there's a formula in there that equates to a 0 or "" though thats handled differently  Register To Reply