condition formatting involving formula

C

chiuinggum

if cell is A1=100

how do i set a conditional formating for the following

1) if cell B1 value is greater than A1 by 20% fill blue
2) if cell B1 value is lower than A1 by 10% fill red
3) if cell B1 value is between condition (1) & (2) fill yellow
 
A

AKphidelt

Go to

Format---> Conditional Formatting

Then you have 3 criterias you can make... just play around with that. Like
you can put greater then A1*.2
 
B

Barb Reinhardt

THe conditional format on b1 would be

=B1>A1*1.2
=B1<A1*0.9

Set the default color to YELLOW
 

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