For some reason 2007 Excel is not doing this for me. So, can you help?
I have the following table...Reference date = TODAY()
1st Col. 2nd Col. 3rd Col
<tbody>
</tbody>
I want to compare the 2nd column date with the reference (will change day by day) date and based on 2 things I want excel to do the following:
1. If all 3 columns contain a date, then nothing is put before the date in the second column. Conditional formatting stops
2. No date in the 3rd column, If the date in the 2nd column is > the reference then a red light shows up before the date in the column.
3. No date in the 3rd column, If the date in the 2nd column is = the reference then a yellow light shows up before the date in the column.
4. No date in the 3rd column, If the date in the 2nd column is < the reference then a green light shows up before the date in the column.
I have tried numerous ways but either nothing is happening or screwy results come up.
Suggestions? Thanks!
I have the following table...Reference date = TODAY()
1st Col. 2nd Col. 3rd Col
10/10/13 | 10/23/13 | 10/28/13 |
11/6/13 | 11/8/13 | |
10/22/13 | 11/11/13 | |
10/22/13 | 11/5/13 |
<tbody>
</tbody>
I want to compare the 2nd column date with the reference (will change day by day) date and based on 2 things I want excel to do the following:
1. If all 3 columns contain a date, then nothing is put before the date in the second column. Conditional formatting stops
2. No date in the 3rd column, If the date in the 2nd column is > the reference then a red light shows up before the date in the column.
3. No date in the 3rd column, If the date in the 2nd column is = the reference then a yellow light shows up before the date in the column.
4. No date in the 3rd column, If the date in the 2nd column is < the reference then a green light shows up before the date in the column.
I have tried numerous ways but either nothing is happening or screwy results come up.
Suggestions? Thanks!