If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|