Help

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.
 
N

Norman Harker

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

Need Help with a VBA subroutine 0
Drop down list control value in vba 2
Date Conditional Formatting 4
need help in creating a formula 1
Conditional Formatting - Cannot get it to work, please help 1
formatting excel date list 5
Word 2003 won't exit 8
Clearing Fields in a Word Form 5

Top