Conditional Formatting is not working properly.

Bert Hoffbeck

I'm using the formula

=IF(ISBLANK([Citizen Doc#]@row), "", IF(TODAY() > [Citizen Exp Date]@row, "Expired", ""))

that will show the word "Expired" if the conditions are met.

The correct records show the word "Expired".

My conditional formatting is to show a red background with white text.

It properly shows this in the fields with "Expired" in them.

But for some of the other blank records, it will also format them with the Red Background and White Text as well as some of the blank field records properly formatted.

I've tried the following:

1. Formatting the entire a different background color in that column to see if that would correct things
2. I've highlighted the Citizen Doc# fields that appear blank and deleted information in them, assuming there might be a space from accidentally pushing the space bar
3. I've removed the conditional formatting for the column and re-entered it.

But nothing I've tried seems to work.

Any suggestions on how to remedy this?

I've attached a couple of screen shots.

Bert

ConditonalFormattingIssue.PNG

ConditonalFormattingSettings.PNG

James Keuning

Do you have any other conditional formatting in this sheet?

I can't really help because this seems bizarre. I would start over in an empty sheet and just set up like three rows of really clean data.