Posted to microsoft.public.excel.worksheet.functions

TSK

external usenet poster

Posts: 21

Conditonal Formatting

Can someone advise me how to change the cell color when date is input

I had the following advise formula for text and number but it does not work
with date format

Format == Conditional Formatting
Formula is: =istext(A1)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
conditonal formatting in VB	JBW	Excel Worksheet Functions	2	October 12th 07 05:02 PM
Conditonal formatting	Hawksby	Excel Discussion (Misc queries)	2	March 9th 07 01:49 PM
Self Tests, and Conditonal Formatting	KiowaPilot	Excel Discussion (Misc queries)	0	January 4th 07 06:49 PM
Conditonal Formatting	Matt	Excel Discussion (Misc queries)	3	April 21st 06 07:42 PM
Protect conditonal formatting	ITGuy	Excel Discussion (Misc queries)	0	March 15th 05 10:47 AM

All times are GMT +1. The time now is 10:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us