Conditional formatting

  • Thread starter Thread starter Fluffy
  • Start date Start date
F

Fluffy

I have a row of dates that are formatted to show the day of the week,
i.e., 'Wed, Fri, etc.

When a cell in the first row is Wed, I want the cell below it to
appear in purple. How?

I have Excel 97.
 
Hi!

Assume the dates are in the range A1:G1.
Select the range A2:G2.
Goto Format>Conditional Formatting.
Select Formula Is and enter this formula:

=WEEKDAY(A1)=4

Click the Format button and select the style(s) you want.
OK out

Biff
 
Back
Top