Solved

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

Posted on 2012-09-21
246 Views
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.

test.xlsx
0
Question by:rayscue

LVL 19

Expert Comment

I updated your conditional formatting in two places... that fixed it... please see updated spreadsheet and screenshot.
conditinalFormat.jpg
Copy-of-test.xlsx
0

LVL 50

Expert Comment

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

LVL 19

Accepted Solution

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

Author Comment

Thanks so much!  works like a charm!
0

## Featured Post

### Suggested Solutions

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.