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, F11Current+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"
wrote in message
...

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