Help with Conditional Formatting

[maximillianrg]

Hello Excel God's and Goddesses - Here again asking for some help, this Time with Conditional formatting

Cell A1 contains a dollar amount and cell B1 contains a % number from 0-100% What I'm looking to do is apply conditional formatting to cell A1 based on the value of cell B1 as follows

If Cell B1 = 0% A1 will be white
If Cell B1 = 1%-29% A1 is green
If Cell B1 = 30%-49% A1 is Yellow
If Cell B1 = 50%-100% A1 is Red

Can someone give me some hints on how to do this?

 

[onlyadrafter]

Hello,

Select call a1, select Conditional Formatting, enter formula =B1=0 format as necessary.

Add another rule =B1<=29, format as necessary.

Continue with other two rules.

To be more specific = =AND(B1>0,B1<=29)

 

[maximillianrg]

Thank you so much - I will test this tonight