[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

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
0
rayscue
Asked:
rayscue
  • 2
1 Solution
 
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
 
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
 
rayscueAuthor Commented:
Thanks so much!  works like a charm!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now