I am doing a CF for expiration dates, I am using the "cell value is" method
to determine if the date is expired, however, it is highlighting any blank
cell as well. Is there a way to prevent the hilighting of blank cells?

Conditional Formatting

=AND($A1<"",$A1<=TODAY())


"ked" wrote:

I am doing a CF for expiration dates, I am using the "cell value is" method
to determine if the date is expired, however, it is highlighting any blank
cell as well. Is there a way to prevent the hilighting of blank cells?

Use formula is instead,

=AND(A2<"",A2--"02/10/06")

as an example



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"ked" wrote in message
...
I am doing a CF for expiration dates, I am using the "cell value is" method
to determine if the date is expired, however, it is highlighting any blank
cell as well. Is there a way to prevent the hilighting of blank cells?

An empty cell formatted as a date equates to 01/00/00.

So, if your CF formula might look like this:

=A1<=Today()
Revise it to something like this:
=And(A1<"",A1<=Today())
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ked" wrote in message
...
I am doing a CF for expiration dates, I am using the "cell value is"
method
to determine if the date is expired, however, it is highlighting any blank
cell as well. Is there a way to prevent the hilighting of blank cells?

Can't believe the coincidence!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Teethless mama" wrote in message
...
Conditional Formatting

=AND($A1<"",$A1<=TODAY())


"ked" wrote:

I am doing a CF for expiration dates, I am using the "cell value is"
method
to determine if the date is expired, however, it is highlighting any
blank
cell as well. Is there a way to prevent the hilighting of blank cells?

Thank you to all of you!!! It works great now!!!!

"Ragdyer" wrote:

An empty cell formatted as a date equates to 01/00/00.

So, if your CF formula might look like this:

=A1<=Today()
Revise it to something like this:
=And(A1<"",A1<=Today())
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ked" wrote in message
...
I am doing a CF for expiration dates, I am using the "cell value is"
method
to determine if the date is expired, however, it is highlighting any blank
cell as well. Is there a way to prevent the hilighting of blank cells?

We all appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"ked" wrote in message
...
Thank you to all of you!!! It works great now!!!!

"Ragdyer" wrote:

An empty cell formatted as a date equates to 01/00/00.

So, if your CF formula might look like this:

=A1<=Today()
Revise it to something like this:
=And(A1<"",A1<=Today())
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ked" wrote in message
...
I am doing a CF for expiration dates, I am using the "cell value is"
method
to determine if the date is expired, however, it is highlighting any
blank
cell as well. Is there a way to prevent the hilighting of blank cells?