Conditional Formatting - Including a Sum()

[OddProject]

Hi, i'm sure you've seen my previous threads (sorry for dominating ).

K.

I have conditonal formatting on my grid with 3 conditions:

=IF(Q4=TRUE,$O4=-1,) go red
=IF(Q4=TRUE,$O4=0,) go orange
=IF(Q4=TRUE,$O4=1,) go green

I now need to include a sum 'I4' (Total) divided by 'M4' (No. of months) in all 3 conditions and I need the sum visibile in my cells that are 'TRUE'.

Is there a way around this?

If you need more info, give me a shout.

Thanks alot guys!

 

[OddProject]

is this possible?

I need this asap.

thanks again

 

[OddProject]

Could someone please advise?

Fair enuff if its not possible, but I need this sorting asap

 

[DCrake]

Unfortunately there is no solution, AFAIK, there is a limit of 3 conditions plus the default making four.

David

 

[Brianwarnock]

I'm sure that it could be done with VBA, even tho' I'm not sure what you are asking.

Brian