Forum Discussion
Formula/Format possibility???
Question will be explain as if you are looking at the attached work book. The date column has Conditional Formats that change colors within 305 - 365 days of the date that is the cell. I'm tr...
Hi,
Will you put date in remarks column? or any other comments.
Coz, Can't understand.
Let's see if I can explain it a little better..... also referred to the attachment
The Date column has conditional formats already that change the color of the cell based on the date that is in it if the date in that cell is more than 305 - 365 days ago.
Is there a conditional format method that I can put in the remarks cells so that if I were to type something in a remarks cell (say like "MP") it would reference the date that is in the date cell on that column and change the remarks cell colors based on shorter time periods like 125 -185 days ago. Instead of having to add the date again.
