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 have viewed the answer for a similar question. If I have several rules for a particular row, (e.g. if cell A2 is 1 then the row is red, if 2 then row is blue, if 3 then row is green, etc...). Having 40 rows and 5 coloring rules, I will have to create 200 rules that is not efficient in my view.

Can I use one rule for all 40 rows, rather than 5 rules for a row?

share|improve this question
up vote 3 down vote accepted

Sure. Apply the rule to all 40 rows and use a formula like this for each rule:

=$A2=1

That should only require five rules.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .