formating the cell background color depends on the value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Click to expand...
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
Click to expand...
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional format - table - cell empty return default color 1
Color cell depending on it's previous value 4
Cell Background Color Change --> Change Event 5
Remove Hyperlinks Without Changing background shading 14
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel Macro to automatically go to the right of the last colored cell 0
count cells with diagonal borders 3
Background color change, by using the formula. 1

Back
Top