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.)


Gotroots wrote:
>
> 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.

--

Dave Peterson

Thank you Dave, that is the solution I was after.

"Dave Peterson" wrote:

> 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.)
>
>
> Gotroots wrote:
> >
> > 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.
>
> --
>
> Dave Peterson
> .
>