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
.