does anyone know how to write the formula to let the pivot table cell checking itself to determine which background color it belong to. since i have 5 options of colors, thanks for your help!

Hi
not really sure what you're trying to do (please explain
with some more detail). But this sounds like it's not
possible with formulas

-----Original Message-----
does anyone know how to write the formula to let the
pivot table cell checking itself to determine which
background color it belong to. since i have 5 options of
colors, thanks for your help!
.

Thanks for your response first. ok, basically i want to load data into the pivot table, one of the column data, i need to do the cell background color setting depend on the value in the cell. basically i can do it on conditional formatting but the problem is i have 5 type of color need to apply whereas conditional formatting only give me three, so what i think i can done is thru by formula, anywhere i still can't figure out the way to do the formula. Lastly thanks a lot

Hi
if you need more than three conditions you'll need VBA for
this (using an event procedure). is this a feasible way
for you?

-----Original Message-----
Thanks for your response first. ok, basically i want to
load data into the pivot table, one of the column data, i
need to do the cell background color setting depend on the
value in the cell. basically i can do it on conditional
formatting but the problem is i have 5 type of color need
to apply whereas conditional formatting only give me
three, so what i think i can done is thru by formula,
anywhere i still can't figure out the way to do the
formula. Lastly thanks a lot
.

hi, what happen is the project didn't include vba only using excel to show the record in the pivot table. so that's is the problem i'm facing. what i thought is i may use the formula statement in the conditional formatting. so i still looking the solution, thank