How do I change color pattern based upon a formula within a cell?

A

aemuk

EXCEL - Can anybody show me the specific keystrokes to direct a cell to be a
certain color pattern based on the following example?

If the entered data in B1 is > data in A1, then make the color pattern in B1
Green
If the entered data in B1 is < data in A1, then make the color pattern in B1
Red
If the entered data in B1 is = data in A1, then make the color pattern in B1
Yellow

Thanks for your help!
 
E

Elkar

Select cell B1
From the Format Menu, choose Conditional Formatting
Select "Cell Value Is Greater Than" then type in =A1
Set your format (green)
Click ADD>>
Select "Cell Value Is Less Than" then type in =A1
Set your format (red)
Click ADD>>
Select "Cell Value Is Equal To" then type in =A1
Set your format (yellow)
Click OK

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top