Thread
:
conditional IF-THEN
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
conditional IF-THEN
Select rows formatconditional formattingformula is
=AND(LEN(TRIM($E1))0,OR(WEEKDAY($E1)=6,WEEKDAY($E 1)=7))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"RedBeard" wrote in message
...
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett