Help

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(A12500,TODAY()B1+5)
Format Button
Select format to taste
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

wrote in message
...
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.