cell AD1 contains "1/2/2006 3:00:00 PM".
cell AD2 contains =AD1
cell AD2 is formatted as special "ddd" , this displays what day it is.
mon , tue, wed, etc...
column AD has the formula copied down 1000 rows.
now the question is: using conditional formatting, how do i look in column AD and find all the "Fri" so i can format there cell's gray?
i have tried the simple formatting, but it seems to be looking at the formula's.
just to add a little , i am using cell AE1 as the cell to look at for what day i am trying to highlight. AE1 contains "Fri" but next week might contain "Mon".
hope i explained this well enough.
cell AD2 contains =AD1
cell AD2 is formatted as special "ddd" , this displays what day it is.
mon , tue, wed, etc...
column AD has the formula copied down 1000 rows.
now the question is: using conditional formatting, how do i look in column AD and find all the "Fri" so i can format there cell's gray?
i have tried the simple formatting, but it seems to be looking at the formula's.
just to add a little , i am using cell AE1 as the cell to look at for what day i am trying to highlight. AE1 contains "Fri" but next week might contain "Mon".
hope i explained this well enough.