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,