Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

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

This question came from our site for professional and enthusiast programmers.

Your Answer

 
discard

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