I was hoping someone might be able to help me with some excel questions.
Attached is the xls created to handle the graphic deparment's project schedule.
Basically I'm trying to use a
conditional format to
1. If today is 3 days or less from and including the due date (col
i,k,m) , the font color in the row will change color (blue).
2. If a date is entered into col N , the font color
in the row will
change color (grey). If the cell does not contain a date it should return to its previous state.
is some formatting that the department would like to remain active on this sheet.
1. There is an existing
conditional format for the cell colors in col
(d,e,f,g,h,j) based on the text entered in the cell (w,r,na)
2. There is a formula for 'comps due' (col i) and
'project route' (col
k) based on the project due date(col m)
Thanks in advance for taking a look at this workbook. -- I look
forward to your feedback!