Conditional formatting doesn't work....

you have selectect A1 to B8
so in conditional formatting it will start looking in cell A1
and then use
$B3<$B2
and highlight row 1 - if that is true
and so the conditional formatting will be out by 1 row

you need the formula to be the correct reference to the row

let me look further and i'll come back here and edit this post

so in your example

$B2<10

change that to
$B1<10

if you do not want to apply to row 1 - often titles

then you would select
A2 to B8
and use
$B2<10

now looking at your other comments

I've also tried =$B3<$B2
=$B3<"$B2"
=$B3<10

"" changes to text

so
<10 is a number
BUT
<"10" is text and so cant do less then a text , although excel does apply a numbering to text - so can be confusing

so
=$B3<"$B2"
again that looking for B3 to be less than a text "$B2" - NOT a cell reference as the "" changes to text
hope that helps

Your rule for A2 should be:

=$B2 < $B$1

The Applies To range is $A$2:$B$8.

EDIT: Clear all other attempts you’ve made before applying this.

Formula:

Formula:

Please Login or Register  to view this content.

applied to

Formula:

Please Login or Register  to view this content.

Or
Formula:

Formula:

Please Login or Register  to view this content.

applied to

Formula:

Please Login or Register  to view this content.

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Don't know which of us you are replying to, but if that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

See post #7 above.