conditional formating
Try changing Condition 1 to Formula Is before adding that formula
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"nk" wrote in message
ps.com...
how to change the color of the font if the day is Sunday?
( i tried the following formating and it dIdn"t work:
CELL VALUE IS "EQUAL TO" =WEEKDAY(A7,1)=1
nk
|