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.

I like to color the backgrounds of the cells which has similar values. There are huge no. of such values so it is not possible to create condition/rule for each. I am looking for a shortcut. Like this -

Image description

share|improve this question
    
You want all of them to be the same color or all of them to be different colors? Like cat, cat, dog, dog all be yellow OR cat, cat be yellow and dog, dog be red? –  Raystafarian Jan 28 at 14:25
    
cat, cat be yellow and dog, dog be red @Raystafarian –  Saik0 Jan 28 at 17:11
    
check here first –  Raystafarian Jan 28 at 17:15
    
@Raystafarian That's good but I was looking for some in-built Microsoft thing :P –  Saik0 Jan 28 at 17:20

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.