ANDIF function

Pam123

New Member
Joined
Jul 28, 2010
Messages
3
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.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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<TODAY()

Set desired format and click OK.

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

HTH


Dave
 
Upvote 0
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??
 
Upvote 0
Try

=$I2+$J2 < NOW()

as the function
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top