W
WSI
Hello -
I have a list of expiration dates and I want to highlight the expired ones.
The list is tranposed from another sheet so it is in a column instead of a
row, so I want to be able to do this without sorting.
For example, here is what the data looks like in
sheet1:
12/31/2007 10/31/2007
sheet2:
12/31/2007
10/31/2007
With the formula being {=TRANSPOSE(Sheet1!A1:B1)} to get these values into
columns (There 86 rows in my actual sheet)
How can I build a conditional format to get the cells to highlight red if
they are earlier than todays date, or yellow if they are within 30 days?
Help is much appreciated!
I have a list of expiration dates and I want to highlight the expired ones.
The list is tranposed from another sheet so it is in a column instead of a
row, so I want to be able to do this without sorting.
For example, here is what the data looks like in
sheet1:
12/31/2007 10/31/2007
sheet2:
12/31/2007
10/31/2007
With the formula being {=TRANSPOSE(Sheet1!A1:B1)} to get these values into
columns (There 86 rows in my actual sheet)
How can I build a conditional format to get the cells to highlight red if
they are earlier than todays date, or yellow if they are within 30 days?
Help is much appreciated!