Formula problem

Hiya guys and gals

I have a tricky problems here, what i have is the following code:

(OR(AND(F11>(Current-26),F11<=Current),F11>(Current+26))

What i need to do is adapt it so that aswell as performing this function it can also be used for conditional formatting.

If the statement is true it will shade a certain colour

I am really stumped here and feel that i am very close but just missing something really simple.

Any help greatly apprieciated

Cheers

James

It looks like AND(F11>(Current-26),F11<=Current) could be simplified to
(Current-F1<26)
So the new formula is =OR(Current-F11<26, F11>Current+26) (removing
unneeded parentheses)

To use in condition formatting.
Select cell; use menu commands Format|Condition Formatting; in dialog box
"Formula is" and type in formula
(DO REMEMBER THE = sign)
Now click format button and set Pattern to red

come back if I have been too brief

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"superkopite" <superkopite.229aiy_1138302901.497@excelforum-nospam.com>
wrote in message
news:superkopite.229aiy_1138302901.497@excelforum-nospam.com...
>
> Hiya guys and gals
>
> I have a tricky problems here, what i have is the following code:
>
> (OR(AND(F11>(Current-26),F11<=Current),F11>(Current+26))
>
> What i need to do is adapt it so that aswell as performing this
> function it can also be used for conditional formatting.
>
> If the statement is true it will shade a certain colour
>
> I am really stumped here and feel that i am very close but just missing
> something really simple.
>
> Any help greatly apprieciated
>
> Cheers
>
> James
>
>
> --
> superkopite
> ------------------------------------------------------------------------
> superkopite's Profile:
> http://www.excelforum.com/member.php...o&userid=29496
> View this thread: http://www.excelforum.com/showthread...hreadid=505456
>

As always that works a treat!!

Thanks alot

James

After more testing, actually anything that is + current is still highlighted.

i'm not too sure what is going wrong.

=OR(Current-F30<26, F30>Current+26)

Anything less than current - 26 is not highlighted, which is correct

but everything above current is highlighted.

As small error that i am sure is easily correct, i am just ashamed to say that my currently abilities make the answer illegible to me!

James

After more testing, actually anything that is + current is still highlighted.

i'm not too sure what is going wrong.

=OR(Current-F30<26, F30>Current+26)

Anything less than current - 26 is not highlighted, which is correct

but everything above current is highlighted.

As small error that i am sure is easily correct, i am just ashamed to say that my currently abilities make the answer illegible to me!

James

After more testing, actually anything that is + current is still highlighted.

i'm not too sure what is going wrong.

=OR(Current-F30<26, F30>Current+26)

Anything less than current - 26 is not highlighted, which is correct

but everything above current is highlighted.

As small error that i am sure is easily correct, i am just ashamed to say that my currently abilities make the answer illegible to me!

James

sorry for the multiple post my browser was playing about

it's okay guy, i managed to work it out (i must be getting good at this!)

i used a combo of all of the above

=OR(AND(F29>(Current-26),F29<=Current), F29>Current+26)

Thanks again guys

James

Well done - great satisfaction getting it to work!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"superkopite" <superkopite.229mkb_1138318501.4469@excelforum-nospam.com>
wrote in message
news:superkopite.229mkb_1138318501.4469@excelforum-nospam.com...
>
> it's okay guy, i managed to work it out (i must be getting good at
> this!)
>
> i used a combo of all of the above
>
> =OR(AND(F29>(Current-26),F29<=Current), F29>Current+26)
>
> Thanks again guys
>
> James
>
>
> --
> superkopite
> ------------------------------------------------------------------------
> superkopite's Profile:
> http://www.excelforum.com/member.php...o&userid=29496
> View this thread: http://www.excelforum.com/showthread...hreadid=505456
>