View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gotroots Gotroots is offline
external usenet poster
 
Posts: 114
Default Conditional fomat series

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.