Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

Can a databar be the same color as the background color of another cell without VB code?

Actually depends on the value of the cell which is calculated average from a pivot table. If value is 0 to 4 color = Red, if value = 5 color = Yellow, if value 6 or 7 then color = Green.

share|improve this question
Welcome to stackoverflow! Do you want to "take" the color of another cell with a formula ? – BrOSs Sep 14 '12 at 1:21
Actually depends on the value of the cell which is calculated average from a pivot table. If value is 0 to 4 color = Red, if value = 5 color = Yellow, if value 6 or 7 then color = Green. – user1670137 Sep 14 '12 at 21:07
Have you tried to add a conditional format for each of those criteria? – CharlieRB Sep 17 '12 at 19:54

migrated from stackoverflow.com Sep 17 '12 at 19:44

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.