Conditional Format
I would like to use the conditional format function to change the
background color of a cell. My spreadsheet contains the following columns: A)Today's Date B) Date of Last Visit C) Date of Next Visit I want to set up an alert system in column C - highlight the cell in column C yellow if it is two months or less prior to today's date - highlight the cell in column C red if it is past today's date (over-due) I have gotten confused on setting up the right equation using the dates. Thanks in advance for assistance. |
Conditional Format
1st condition: =A2C2 color: red
2nd condition: =month(C2)-month(A2)<=2 color: yellow Regards, Stefi €˛mary€¯ ezt Ć*rta: I would like to use the conditional format function to change the background color of a cell. My spreadsheet contains the following columns: A)Today's Date B) Date of Last Visit C) Date of Next Visit I want to set up an alert system in column C - highlight the cell in column C yellow if it is two months or less prior to today's date - highlight the cell in column C red if it is past today's date (over-due) I have gotten confused on setting up the right equation using the dates. Thanks in advance for assistance. |
All times are GMT +1. The time now is 02:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com