Changing cell color if date is...
 

Hello,
How do i change the cell color in case the date in the cell is due after 3
months..?? and where i put the code if you give it to me...

thanks

Changing cell color if date is...
 

You can use conditional formatting.

Assuming your date cell in A1. Go to Menu-Click Format- Conditional
Formatting

Click formula is, and paste the formula into it. Then, go to format and
format the way you want it, eg. go to the pattern tab to change the cell
colour.

=AND(DAY(TODAY())=DAY(A1),MONTH(TODAY())-MONTH(A1)=3,TODAY()-A1=90)

If you have multiple cells, select all the cells by clicking on A1 then
shift click the rest. Make sure A1 is selected, then conditional format
it by putting in the same formula.

The conditions above should be accurate enough to take care of most
conditions. Enjoy.


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=550750