Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to program a worksheet to make the cells turn
red when the row exceeds a $2,500 amount, but it has to be
able to do it after a a specific date like 5 days from the
original date. Can anyone tell me how to do this??? I
really need help.
 
Hi mmagee!

You need Conditional Formatting

Assuming the cell with the amount is A1 and the original date is in B1

Format > Conditional Formatting
Formula Is
=AND(A1>2500,TODAY()>B1+5)
Format Button
Select format to taste
OK
 
Back
Top