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?
|