Conditional Formatting values in a column based on values in another column

I have an Excel spreadsheet that I want to show the values in column B in red if the corresponding value in column A is less than the value in column B.

I have the first row formatted, but when I try to use the format painter, all of the cells in column B have red font instead of just those that are less than their corresponding value in column A.

Can you help please?
test.xlsx
rayscueAsked:
Who is Participating?
 
Ken ButtersCommented:
Yep.... I saw that... I tried to update my attachment in original comment but wasn't quick enough.. :)
conditinalFormat.jpg
Copy-of-test.xlsx
0
 
Ken ButtersCommented:
I updated your conditional formatting in two places... that fixed it... please see updated spreadsheet and screenshot.
conditinalFormat.jpg
Copy-of-test.xlsx
0
 
barry houdiniCommented:
Doesn't that still have all cells in column B highlighted, buttersk?

Format painter works OK but you have the wrong formula, you need to remove $ signs otherwise every row is formatted based on the values in row 1 (so either all rows will be formatted or none), to make sure every row is formatted based on the values in that row change formula to

=B1<A1

see attached

regards, barry
barry-test.xlsx
0
 
rayscueAuthor Commented:
Thanks so much!  works like a charm!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.