Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 '14 at 14:25
cat, cat be yellow and dog, dog be red @Raystafarian – Saik0 Jan 28 '14 at 17:11
check here first – Raystafarian Jan 28 '14 at 17:15
@Raystafarian That's good but I was looking for some in-built Microsoft thing :P – Saik0 Jan 28 '14 at 17:20

You must log in to answer this question.

Browse other questions tagged .