Help with formula

[CB]

I have the following inserted as a condition for formatting.
=AND(RIGHT($A1,5)="Total",F1=100)
How can I modify this to format if the value is between 100 and 105?
Thanks,
CB

 

[Don Guillett]

Did you try inserting another parameter?

 

[FSt1]

hi
try this.....
=AND(RIGHT($A1,5)="Total",AND(F1>100,F1<105))
if you want to include 100 and 105 then
=AND(RIGHT($A1,5)="Total",AND(F1>99,F1<106))

reguards
FSt1

 

[CB]

FSt1.
This works perfect. Thanks so Much.....
CB