• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

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
0
Andreamary
Asked:
Andreamary
1 Solution
 
NBVCCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now