conditional formatting
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
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? |
conditional formatting
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? |
conditional formatting
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? |
conditional formatting
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? |
conditional formatting
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? |
conditional formatting
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? |
All times are GMT +1. The time now is 02:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com