conditional formating
 

I have three columns. A contains actual values this month, B contains yearly
average, C contains sales target. I need to conditionally format column A if
the value in A is 10% above the value in B and 20% above value in C.

Also if the value in column A is below the value in B and C I need to colour
it a different colour.

Please help and thanks

Bob

conditional formating
 

Use CF with a condition of Formula Is and formulae of

=AND(A1B1*110%,A1c1*120%)

and

=AND(A1<B1,A1<C1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bob" wrote in message
...
I have three columns. A contains actual values this month, B contains
yearly
average, C contains sales target. I need to conditionally format column A
if
the value in A is 10% above the value in B and 20% above value in C.

Also if the value in column A is below the value in B and C I need to
colour
it a different colour.

Please help and thanks

Bob