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