Excel: Format Cell's which are less than the cell beside it to another color

I have a spreadsheet of values. I want to format cells in column b which are less than the relative cell in column a to another color.
Office 2007
gswitzAsked:
Who is Participating?
 
Patrick MatthewsConnect With a Mentor Commented:
Assuming you want to apply this to, say, B2:B1000...

1) Select B2:B1000

2) Go to Conditional Formatting on the Home tab of the Ribbon, and add a new rule

3) Make the rule formula-based, using:

=B2<A2

and select your desired color
0
 
gswitzAuthor Commented:
I also need to be able to copy the format to other cells where only the format is added to the cells... not the values.
0
 
jppintoConnect With a Mentor Commented:
Please take a look at the attached image and sample file.

jppinto
Capturar.JPG
conditional-format.xlsx
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Patrick MatthewsCommented:
As for copying formats, use Paste Special instead of Paste.
0
 
jppintoCommented:
If you want to be able to copy the CF to other cells, take a look at the attached image.

jppinto
Capturar.JPG
0
 
gswitzAuthor Commented:
I can't get any of this to work. I need it not to be all on the top cell in column A.

I want cell B3 to highlight only when less than A3 not when less than A2.
0
 
Patrick MatthewsCommented:
In that case, select B3:B???, and change the formula to =B3<A3
0
 
gswitzAuthor Commented:
I opened jppinto's spreadsheet and copied a cell. I pasted - special - format over mine and they all turned yellow.
0
 
jppintoCommented:
Can you check what CF rule you got on one of those cells?
0
 
gswitzAuthor Commented:
Thanks. I succeeded.
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.