Today is 14-Nov-12 Hello Forum, appreciate some help with this headache
The office has a large spreadsheet where Column A has a "start date" and Column B "Clearance Date"
We would like to see a red font for those dates that have passed the current date.
A yellow cell for dates that are within a 28 day period. That is there is a 28 day grace period to have processing done.
If at all possible is there a way of formatting (over-riding Column A) font to green and white background when a date is input to Column B?
Maybe I need hidden columns with other formulas?
<TBODY>
</TBODY>
Thank you, Pete
The office has a large spreadsheet where Column A has a "start date" and Column B "Clearance Date"
We would like to see a red font for those dates that have passed the current date.
A yellow cell for dates that are within a 28 day period. That is there is a 28 day grace period to have processing done.
If at all possible is there a way of formatting (over-riding Column A) font to green and white background when a date is input to Column B?
Maybe I need hidden columns with other formulas?
A | B | |
1 | Start Date | Clearance Signed (28 day grace) |
2 | 02-May-12 | 01-Jun-12 |
3 | 30-May-12 | |
4 | 28-Jun-12 | |
5 | 14-Nov-12 | |
6 | 17-Nov-12 | |
7 | 14-Jan-13 | |
8 | 14-Jan-13 |
<TBODY>
</TBODY>
Thank you, Pete
Last edited: