If Statement with Conditional Formatting using <>=

[cparks]

I have a column of accounts and a rank in another...with many columns in between. I want to highlight accounts that reflect a color based on their rank "group" given a <,>,and/or = (i.e. 1-3, 4-6, 7-10)

I have used this sort of formula before but cant find the file...
Ive tried using the "&" within the formula I cant figure out how I used it without getting error pop ups.

 

[Somendra Misra]

Hi,

Based on your sample file, see I had created below formulas.


Formula used for GREEN: =AND($B2>=1,$B2<=3)

for rest you can modify the conditions.

Regards,

 

[cparks]

Wow!...So simple. I was looking too far into it plus having a long days work and being late. Just put it all in and it works...obviously. Thanks so much and for your timely response!!

Hi,

Based on your sample file, see I had created below formulas.


Formula used for GREEN: =AND($B2>=1,$B2<=3)

for rest you can modify the conditions.

Regards,