Excel - Conditional formatting
I have a column with dates (eg 10/15/2015) with the next column calculating the weekday (eg. =WEEKDAY(F9,1)); there weekday column is formatted to display a 3 character weekday [DDD].
I want to set Conditional Formatting to make cells with "Sat" and "Sun" to appear red. How do I make the Conditional recognize the resulting displayed text "Sun" and not the formula "=WEEKDAY(F9,1)"
Thank you,
JohnD
I want to set Conditional Formatting to make cells with "Sat" and "Sun" to appear red. How do I make the Conditional recognize the resulting displayed text "Sun" and not the formula "=WEEKDAY(F9,1)"
Thank you,
JohnD
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER