How to Display Conditional Formatting of One Cell Based on Another

[dmingle]

Objective: to display conditional formatting of one cell based on another
Conditions:

• If the cell is blank = white
• if the cell has a value less than variable X = green
• if the cell has a value equal to or greater than 1.24 of * X = yellow
• If the cell value is greater than 1.25*X = red.
• {X is the benchmark value}

Problem:
All conditional formatting works as it should, however when the value is blank it defaults to the red color. It should be white.

Here is the formula that I have in the conditioned cell:

=IFNA(ROUND(HLOOKUP(A16,Login!$C$1:$ZZ$1000,2,FALSE),2),"")

If you take the IfNA() function out of the above formula the result would be "#N/A". This formula recognizes the #NA result and transforms it to "".

I appreciate any help.

 

[Caribeiro77]

Objective: to display conditional formatting of one cell based on another
Conditions:

• If the cell is blank = white
• if the cell has a value less than variable X = green
• if the cell has a value equal to or greater than 1.24 of * X = yellow
• If the cell value is greater than 1.25*X = red.
• {X is the benchmark value}

Problem:
All conditional formatting works as it should, however when the value is blank it defaults to the red color. It should be white.

Here is the formula that I have in the conditioned cell:

=IFNA(ROUND(HLOOKUP(A16,Login!$C$1:$ZZ$1000,2,FALSE),2),"")

If you take the IfNA() function out of the above formula the result would be "#N/A". This formula recognizes the #NA result and transforms it to "".

I appreciate any help.

On the conditonal format dialogue box put that blank cell condition on top...