Conditional formatting

[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.

 

[Biff]

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