Hi all,
I am using the following formula for conditional formatting:
=COUNTIF($A$70:$A$84,$E5)
It checks to see if E5 (actually every cell in E) matches A70-84 and if so it changes the format. A70-84 contains a list of state abbreviations & it works great. However, now I want to change the information that the changes the formatting.
Instead of state abbreviations, I want the formatting to change IF there is a DATE being held in the cells in E. It doesn't matter what the date is, just that it is a date. Any other data should be ignored.
Any pointers on this one?
Thanks!
Paul
I am using the following formula for conditional formatting:
=COUNTIF($A$70:$A$84,$E5)
It checks to see if E5 (actually every cell in E) matches A70-84 and if so it changes the format. A70-84 contains a list of state abbreviations & it works great. However, now I want to change the information that the changes the formatting.
Instead of state abbreviations, I want the formatting to change IF there is a DATE being held in the cells in E. It doesn't matter what the date is, just that it is a date. Any other data should be ignored.
Any pointers on this one?
Thanks!
Paul