Conditional Formatting

[flds]

Hi,

I am looking for a formula to find pecentage of a cell based on another cell. I will have to use conditional formatting. I am not familar in using it.

example: A1=16, B1= 25, C1=10 D1=8

Base Cell is A1

if B1 > 20% B1 to change colour to yellow
if B1 < 20% B1 to change colour to Blue
if the above criteria does not match no colour.

Can someone tell me how to do this.

Your help would be appreciated.

Thanks
FLDS

 

[snoopyhr]

Don't you mean if B1>=20% of A1 ? instead of B1 > 20% B1 ?

 

[grizz]

you could use conditional format in B1 cell value
greater than =1.20*A1 and format yellow -- then add conditional format
less than =0.80*A1 and format blue

 

[flds]

Thanks Snoopyhr, you are right that what I ment.

Thanks Grizz, I used your suggestion. it worked.

Done