Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
All cells in my worksheet have a maroon interior color and white text. When
I print the worksheet, I print it in Black and White only to avoid printing in color. I have cells in a column that represent a shipping date that uses the Date format: "9/14/08". I want to put some sort of indicator in the cell that tells the user that the shipping date is late. For example, if the shipping date is late then display "9/14/08*". This is the problem, it displays "9/14/2008*", why? Remember I can't use a different interior color as an indicator, because I print in black and white only. Unless there is a way to print the "indicated" cells color and the rest in black and white only. -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
How come I need to enter a cell in order for the formatting to apply correctly??? | Excel Discussion (Misc queries) | |||
Excel does not displaying formatting correctly | Excel Discussion (Misc queries) | |||
Macro not formatting correctly | Excel Discussion (Misc queries) | |||
numeric value is not formatting correctly | Excel Discussion (Misc queries) |