conditional IF-THEN

[RedBeard]

Greetings,

I have a column with different weekdays in different sheets.
What I want to do is this:

Whenever a user fills in Saturday or Sunday, I want the corresponding
row to turn red, this should be universal for all sheets.

Am I making sense and how would I accomplish this?

Thanks.

 

[Don Guillett]

Select rows format>conditional formatting>formula is
=AND(LEN(TRIM($E1))>0,OR(WEEKDAY($E1)=6,WEEKDAY($E1)=7))

 

[RedBeard]

Select rows format>conditional formatting>formula is
      =AND(LEN(TRIM($E1))>0,OR(WEEKDAY($E1)=6,WEEKDAY($E1)=7))

I forgot to mention, I'm using Excel 2007.

I can't seem to find that command?

Thanks.

 

[Bernard Liengme]

Follow instructions shown in
http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html
best wishes

 

[RedBeard]

Follow instructions shown inhttp://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html
best wishes

Thanks Bernard,

But not useful to me, I need the entire row to change colour, not just
cells.

Thanks.

 

[Bernard Liengme]

Then select the entire row before you call up the Conditional Foramtting
dialog.
I though you just meant "where do I find Conditioanl Formatting"
best wishes