Highlight cells less than 100% but ignore blanks

[sharky12345]

I'm trying to use the conditional formatting option to highlight cells where the value is less than 100%, (the cell values are percentages), but I need to ignore any cells that are blank.

Can anyone help me please?

 

[mohadin]

Hi
try

=IF(AND(A1<>"",A1=100%),"TRUE","FALSE")

 

[Fluff]

Maybe
=AND(A1<>"",A1<1)

 

[sharky12345]

Perfect, thanks guys!

 

[mohadin]

You are well come

 

[Fluff]

Glad to help & thanks for the feedback