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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Patrick MatthewsCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jppintoCommented:
Please take a look at the attached image and sample file.

jppinto
Capturar.JPG
conditional-format.xlsx
0
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.