coloring rows based on criteria

[neeraj]

If I want that the entire row to be colored whenever a
cell has a certain value, say if cell has the value "A",
then the entire row should be colored red, if "B", then
green and so on. How can I achieve this task.

 

[Bob Phillips]

Neeraj,

As long as there are no more than 3 criteria, you can use conditional
formatting

Select the row, goto Format>Conditional Formatting
Change Condition1 to IsFormula
Add your test, =$A1="A"
Select the format button and set font, pattern as required
Add further conditions as required

Then copy the row format to other required rows.

 

[neeraj]

I have about 12 criterias
Conditional format wont work as u have pointed out. Any
more suggestions ?

 

[Bernard V Liengme]

You could 'consolidate' the criteria. Rather than condition-1 as $A1="A" and
condition-2 as $B1="B", use only one condition i.e: AND($a1="a", $b1="b")
Bernard