conditional formula - little bit of twist for my report.
 

hello again,

i have two reference columns A & B
column A contains text, column B contains numbers

i also have another two columns C & D
column C contains text, column D contains the numbers.

D must be the sum of B

Otherwise,
e.g
A B C D
12 5 12 12
12A 10 13 54
12B 5
12C 1
13 6
13.01 3
13.02 45


I need to place a color red on Column A (2 digit prefix of A = C) when the
sum in B
is not equal to the value of D.

from the table above : 12, 12A, 12B & 12C should turns to red.

If theres a conditional formula available for column A, please share again.


--
regards,

conditional formula - little bit of twist for my report.
 

You have replies in your previous question.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"driller" wrote in message
...
hello again,

i have two reference columns A & B
column A contains text, column B contains numbers

i also have another two columns C & D
column C contains text, column D contains the numbers.

D must be the sum of B

Otherwise,
e.g
A B C D
12 5 12 12
12A 10 13 54
12B 5
12C 1
13 6
13.01 3
13.02 45


I need to place a color red on Column A (2 digit prefix of A = C) when the
sum in B
is not equal to the value of D.

from the table above : 12, 12A, 12B & 12C should turns to red.

If theres a conditional formula available for column A, please share
again.


--
regards,

conditional formula - little bit of twist for my report.
 

Sir Bob, sorry for a late response, can this twisted conditional formulation
possible in this type of tabulation?
thanks again
--
regards,



"Bob Phillips" wrote:

You have replies in your previous question.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"driller" wrote in message
...
hello again,

i have two reference columns A & B
column A contains text, column B contains numbers

i also have another two columns C & D
column C contains text, column D contains the numbers.

D must be the sum of B

Otherwise,
e.g
A B C D
12 5 12 12
12A 10 13 54
12B 5
12C 1
13 6
13.01 3
13.02 45


I need to place a color red on Column A (2 digit prefix of A = C) when the
sum in B
is not equal to the value of D.

from the table above : 12, 12A, 12B & 12C should turns to red.

If theres a conditional formula available for column A, please share
again.


--
regards,