software

Hiya guys and gals

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

(OR(AND(F11gt;(Current-26),F11lt;=Current),F11gt;(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: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=505456It looks like AND(F11gt;(Current-26),F11lt;=Current) could be simplified to
(Current-F1lt;26)
So the new formula is =OR(Current-F11lt;26, F11gt;Current 26) (removing
unneeded parentheses)

To use in condition formatting.
Select cell; use menu commands Format|Condition Formatting; in dialog box
quot;Formula isquot; 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

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

As always that works a treat!!

Thanks alot

James--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=505456
After more testing, actually anything that is current is still
highlighted.

i'm not too sure what is going wrong.

=OR(Current-F30lt;26, F30gt;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--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=505456
After more testing, actually anything that is current is still
highlighted.

i'm not too sure what is going wrong.

=OR(Current-F30lt;26, F30gt;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--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=505456
After more testing, actually anything that is current is still
highlighted.

i'm not too sure what is going wrong.

=OR(Current-F30lt;26, F30gt;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--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=505456
sorry for the multiple post my browser was playing about--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=505456
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(F29gt;(Current-26),F29lt;=Current), F29gt;Current 26)

Thanks again guys

James--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=505456Well done - great satisfaction getting it to work!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;superkopitequot; gt;
wrote in message
...
gt;
gt; it's okay guy, i managed to work it out (i must be getting good at
gt; this!)
gt;
gt; i used a combo of all of the above
gt;
gt; =OR(AND(F29gt;(Current-26),F29lt;=Current), F29gt;Current 26)
gt;
gt; Thanks again guys
gt;
gt; James
gt;
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread: www.excelforum.com/showthread...hreadid=505456
gt;