Change font color in columns A, B, & C based on first instance of text in column E

I have a list of inventory items. I would like to find out the most efficient way to trigger a font color change (to blue) of the text in columns A, B & C based on every first instance of a phrase in column E. I've attached a sample file called "Changing font color.xlsx" to help illustrate what I'm looking for.
Thanks,
Andrea
Changing-font-color.xlsx
AndreamaryAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
NBVCConnect With a Mentor Commented:
Select A2:C16 and invoke Conditional Formatting from Home tab.

Then select New Rule, and then 'use a formula to determine which cells to format"

enter formula:

=$E2<>$E1

click format and choose from Font tab.
0
 
AndreamaryAuthor Commented:
Works perfectly...and many thanks for the quick response!
0
All Courses

From novice to tech pro — start learning today.