Conditional Formatting Formula Help

[sadielynn7]

I need to create three separate Conditional Formatting rules; I have tried many different IF, AND, IFS formulas and none of them are doing what we need
I need to use the formulas in conditional formatting so that the cells auto-color based on it as well

If cell D7 is > 0 and < 10000 then put "Leads" in cell K7

If cell D7 is >= 10000 and <=24999 then put "Management" in cell K7

If cell D7 is >=25000 then put "Secondary" in cell K7

 

[etaf]

thats not conditional formatting

In K7 put


What if cell is blank or zero
=IF( And(D7>0,D7 < 10000), "Leads", If( D7 < 25000, "management", If( D7 >= 25000, "Secondary", "")))

Now in conditional formatting you need 3 rules - 1 for each colour

1 =AND( $D7>0, $D7 <10000)
2 =$D7<25000
3 =$D7>=25000
put in that Order and STOP IF TRUE

 

[sadielynn7]

THANK YOU!!!! I realized after I posted that I needed to put the formula in the actual cells and then conditional format for the color based on the text the formula put - I got it do exactly what I needed -Thank you so much!

 

[etaf]

you are welcome