Conditional Formatting Question

[DKRbella0814]

Can someone help me understand why my conditional formatting conditions are not working correctly?

I have a score (formatted as a % in cell $k$10)

I want the following to happen:

1. If $k$10 is blank, I want the cell to be blank (no shading)

2.. If the percentage (on the scale from 1-100, formatted as %) in a specifically referenced cell in the range of B6:B106 is <= $k$10, then I want the cell to be shaded gray

3.. If the specifically referenced cell in range of b6:b106 is >$k$10, then I want the cell to be blank (no shading)





This is how I have written the conditions in the excel program:

1. Condition#1 : If Cell Value is Equal To ="", No Format Set

2. Condition#2 : If Formula Is =if($b106>$k$10,""), Gray Shading

3. Condition#3 : If Formula Is =if($b106>$k$10), No Format Set

 

[Des1gn1ng0ne]

You have given two different options in your post.
If you want less than or equal to 'K10', select 'Formula Is" and enter

=$B6<=$K$10

If you want only values less than 'K10', select 'Formula Is" and enter

=$B6<$K$10

There really is no reason to include a "No Format Set" option unless you have manually changed the cell format. Excel will automatically remove the format if the values are out of range.