If the value in A1 is a date (a real number), then you could use this kind of
conditional formatting formula to check to see if it is Saturday or Sunday:

=WEEKDAY(A1,2)5



Buro AP wrote:

Hi,

I want some cells to turn gray if the data contained therein is a date
number such as 39485. How do I create a condition that can determine that?
I was able to get it to work when the cell was filled with a text "Sat" or
"Sun", but now that I've managed to have the actual serial number display as
"Sat" and "Sun" the condition no longer applies because the returned value is
a number and not text.
--
Earn extra cash from your computer!
Visit http://24hourwebcash.com/curiale1234

God Bless,

Tony

--

Dave Peterson