S
SL
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!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
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
background color it belong to. since i have 5 options of
colors, thanks for your help!
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
pivot table cell checking itself to determine which-----Original Message-----
does anyone know how to write the formula to let the
background color it belong to. since i have 5 options of
colors, thanks for your help!
S
SL
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
F
Frank Kabel
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?
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
if you need more than three conditions you'll need VBA for
this (using an event procedure). is this a feasible way
for you?
load data into the pivot table, one of the column data, i-----Original Message-----
Thanks for your response first. ok, basically i want to
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
S
SL
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