View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Buro AP Buro AP is offline
external usenet poster
 
Posts: 2
Default Conditional formats for date Serial Numbers

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