Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formats Date Based | Excel Discussion (Misc queries) | |||
generate serial numbers and date it entered | Excel Discussion (Misc queries) | |||
Changing text dates to date serial numbers | Excel Worksheet Functions | |||
Changing date serial numbers | Excel Discussion (Misc queries) | |||
Date and sequential serial numbers | Excel Programming |