I want any date 90 days or older from current date change color
I am trying to set up a worksheet for work. I would like to have some
conditional formatting. In the date worked column will be dates going back months if not years. I would like to set up color changes for dates that are 90, 120, 150 days older then the date at the time of opening the worksheet =now(). Dates that are less then 90 days will have no color. I am a fisherman and with this worksheet I could tell in a glance how long it had been since I last worked an area. |
I want any date 90 days or older from current date change color
If A1 has the cell you want to change color and it contains the date the last time you were in an area, try the following: FORMAT/CONDITIONAL FORMATING In Condition 1 choose FORMULA IS from the dropdown In the formula area type =NOW()-A190 Then hit condition and format as you wish (change background, text color, etc) Do the same and change 90 to what ever length you want to check for. This will subtract A1 from today's date, and if 90, it will format as you set. Happy & Safe fishing. John -- JohnGuts ------------------------------------------------------------------------ JohnGuts's Profile: http://www.excelforum.com/member.php...o&userid=30174 View this thread: http://www.excelforum.com/showthread...hreadid=535275 |
I want any date 90 days or older from current date change col
"JohnGuts" wrote: If A1 has the cell you want to change color and it contains the date the last time you were in an area, try the following: FORMAT/CONDITIONAL FORMATING In Condition 1 choose FORMULA IS from the dropdown In the formula area type =NOW()-A190 Then hit condition and format as you wish (change background, text color, etc) Do the same and change 90 to what ever length you want to check for. This will subtract A1 from today's date, and if 90, it will format as you set. Happy & Safe fishing. John -- JohnGuts ------------------------------------------------------------------------ JohnGuts's Profile: http://www.excelforum.com/member.php...o&userid=30174 View this thread: http://www.excelforum.com/showthread...hreadid=535275 Thanks I will give it a go tomarrow...beat now, will let you know |
I want any date 90 days or older from current date change color
OK good luck. FYI, you can use up to 3 conditions in the conditional formating. Do the 1st one with 90 days, the second with 120, etc. John -- JohnGuts ------------------------------------------------------------------------ JohnGuts's Profile: http://www.excelforum.com/member.php...o&userid=30174 View this thread: http://www.excelforum.com/showthread...hreadid=535275 |
I want any date 90 days or older from current date change col
"JohnGuts" wrote: OK good luck. FYI, you can use up to 3 conditions in the conditional formating. Do the 1st one with 90 days, the second with 120, etc. John -- JohnGuts ------------------------------------------------------------------------ JohnGuts's Profile: http://www.excelforum.com/member.php...o&userid=30174 View this thread: http://www.excelforum.com/showthread...hreadid=535275 Ok, it works except the cells in the date column without dates also are filled with color. Is there a way to not to have the empty cells filled. Every other cell in the date column is empty. Can I keep them from coloring also. |
I want any date 90 days or older from current date change col
See your post in the excel group.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Big Abalone" wrote in message ... "JohnGuts" wrote: OK good luck. FYI, you can use up to 3 conditions in the conditional formating. Do the 1st one with 90 days, the second with 120, etc. John -- JohnGuts ------------------------------------------------------------------------ JohnGuts's Profile: http://www.excelforum.com/member.php...o&userid=30174 View this thread: http://www.excelforum.com/showthread...hreadid=535275 Ok, it works except the cells in the date column without dates also are filled with color. Is there a way to not to have the empty cells filled. Every other cell in the date column is empty. Can I keep them from coloring also. |
All times are GMT +1. The time now is 05:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com