Why is data validation still being applied to blank cells when they are ignored?

[Ironman]

Hi

Cells H12:H8000 contain filled and blank cells and the entire range is shaded. I have highlighted the range and data validated it, and the option to 'ignore blank cells' remains checked by default.

The problem is the blank cells in the range still behave as if they are filled i.e. they are also validated.

Is there something else I need to do or is it that because the blank cells are shaded then they 'don't count as being blank' even though they don't contain a value? If this is the case, is there a way around this?

Thanks for your help!

 

[Michael M]

Hi Paul
I might be misreading your question, but how is the entire range shaded ??
Have you turne "Ignore Blanks" off manually ??
Is all of the above driven by code ??

 

[NoSparks]

Do a Google search for
What does ignore blank in data validation mean?

 

[Ironman]

@Michael M Hi Michael, the cells are conditionally formatted, not coded. Edit - no, "Ignore blanks is on".
@NoSparks - Hi Nolan, thanks for that - I always make a point of Googling first, but clearly the phrasing of the question makes a lot of difference, thank you! Looking at the solution it's not simple is it?!

 

[NoSparks]

Looking at the solution it's not simple is it?!

Solution??
Hell, I can't even figure out what the problem is.