coloring rows based on criteria

  • Thread starter Thread starter neeraj
  • Start date Start date
N

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.
 
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.
 
I have about 12 criterias
Conditional format wont work as u have pointed out. Any
more suggestions ?
 
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
 
Back
Top