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