Conditonal Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TSK - 07 May 2008 09:38 GMT

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 to this Message

Pete_UK - 07 May 2008 10:02 GMT

You can't check specifically for dates, as these are just numbers to
Excel. So, you could have:

Formula Is: =ISNUMBER(A1)

or:

Formula Is: =A1<>""

which will check for non-blanks, but then if the cell is blank it
doesn't matter what the format is !!

Hope this helps.

Pete

> Can someone advise me how to change the cell color when date is input
>
[quoted text clipped - 3 lines]
> Format ==> Conditional Formatting
> Formula is: =istext(A1)

Reply to this Message

Max - 07 May 2008 10:33 GMT

Think you could try this
Formula is: =LEFT(CELL("format",A1))="D"

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Can someone advise me how to change the cell color when date is input
>
[quoted text clipped - 3 lines]
> Format ==> Conditional Formatting
> Formula is: =istext(A1)

Reply to this Message