Hello all,
I'm stumped...
I have a list in col $AB$7:$AE$21 in which the operator types in a day
(vacation), ie. 1/11/07
and in $B$7:$X$39 I have a calendar for 2007
I am trying to Cf the calendar to turn a/the cell (date) that matches the
vacation (date)in the col of typed vaction days to a blue with white font,
when it finds a match.
I have dabbled in the Cf with: 'If Cell Value Is:' MATCH, COUNTIF,
DATEVALUE, IF, but my skills in that area are still in it's fetal stages.
Any help is greatly appreciated.
TIA