ANDIF function

[Pam123]

Is it possible to write a formula that will compare a date and time and make the font RED if it meets a specific criteria? EX: If I2 thru I100 AND J2 thru J100 are < the current date and time, THEN change the font color to RED. I would want it to look at I2 & J2 and change if meets criteria, then I3 & J3 etc.

[dave3009]

Hi Pam123 and welcome to the forum

You could use conditional formatting for this I'm sure, highlight range I2 to J200 goto Format>>Conditional Formatting>>Formula Is:

=I2
Set desired format and click OK.

Now dates < today in I2:J100 will display in desired format.

HTH


Dave

[Pam123]

Hi Dave..Thanks, but this doesn't work because I need it to do the comparison in conjunction with one another. ie: Todays date (column I) is 07/28/2010 and the time (column J) is 20:07. I want it to look at column I and J for any date/time prior to 07/28/2010 20:07. Is this even possible??

[dave3009]

Try

=$I2+$J2 < NOW()

as the function

[Pam123]

That didn't work either, Dave. I think i am just out of luck, but thanks for trying.

[PA HS Teacher]

Did you use
'Formula Is'

and enter:
=$I2+$J2 < NOW()

(Then copy the formatted cell) (say, K2?)
and do a paste special, formats to K3:K100