Help with formula
 

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

Help with formula
 

Did you try inserting another parameter?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CB" wrote in message
...
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

Help with formula
 

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

reguards
FSt1

"CB" wrote:

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

Help with formula
 

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

"FSt1" wrote:

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

reguards
FSt1

"CB" wrote:

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

Help with formula
 

You don't need the second IF.
=AND(RIGHT($A1,5)="Total",F1100,F1<105) or
=AND(RIGHT($A1,5)="Total",F1=100,F1<=105)

[Note that 99 is not the same as =100, similarly <106 is not the same as
<=105.]
--
David Biddulph

"FSt1" wrote in message
...
hi
try this.....
=AND(RIGHT($A1,5)="Total",AND(F1100,F1<105))
if you want to include 100 and 105 then
=AND(RIGHT($A1,5)="Total",AND(F199,F1<106))

reguards
FSt1

"CB" wrote:

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