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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting 2
formatting excel date list 5
Ranking Question 3
averaging & ??? 6
Excel Formatting with dates 3
Conditional Formula Help Please! 4
SET A COLOUR 1
Can I have a cell change to red/green if not equal to: 7

Back
Top