I have a list of items (ex: car, blender, bowl, chair, table, etc) and it
gets updated everyday. I want to highlight 20 of these items, and make sure
that they, and the rows they are in, are automatically highlighted when I
update the file. How can I do this?

Conditional data formatting only works if you have 3 or less conditions.

Thank you,

Johanna

Johanna

Put the list of items you want to highlight in a column on another sheet.
Give the column a name, for example, CFList.

Then, in your conditional format, refer to the CFList (Conditional
Formatting List)

=COUNTIF(CFList,$A4)0 and set the format you want, for example, font =
red

Regards

Trevor


"ladybugathena" wrote in message
...
I have a list of items (ex: car, blender, bowl, chair, table, etc) and it
gets updated everyday. I want to highlight 20 of these items, and make
sure
that they, and the rows they are in, are automatically highlighted when I
update the file. How can I do this?

Conditional data formatting only works if you have 3 or less conditions.

Thank you,

Johanna