Conditional fomat series

  • Thread starter Thread starter Gotroots
  • Start date Start date
G

Gotroots

What is the best way to apply conditional formatting to a large number of
rows where each row is distinct from each other.

Example:

A1:H1 should contain the value "Car" if not then conditional format to see
which cells contain unique values.

A2:H2 should contain the value "Lorry" if not.......

Every row thereafter follows the same condition.

How do I apply conditional formatting to a large number of rows where each
row has a distinct conditional formatting requirement.
 
I think I'd use column I to hold the value that should be checked.

Then I could select A1:H999
and with A1 the activecell
Format|Conditional formatting
Cell Value Is Not Equal to =$I1

Excel will keep the column fixed, but adjust the row number -- just like when
you copy|paste formulas.

(I'm not sure what follows the same condition means.)
 
Back
Top