Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formats for date Serial Numbers
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formats for date Serial Numbers
Thanks Dave. Your formula returned TRUE. I read and experimented a little
more and came up with this: =TEXT(B2,"ddd") Where B2 contains my reference date. The resultant text was able to trigger the conditional cell formatting of gray for "Sat" or "Sun". Subsequent cells add 1 to the previous cell value thus: =TEXT((B2+1),"ddd"); =TEXT(C2+1),"ddd") and this worked. Thanks for the help! -- Earn extra cash from your computer! Visit http://24hourwebcash.com/curiale1234 God Bless, Tony "Dave Peterson" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |