Solved

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

Posted on 2013-10-23
2
246 Views
Last Modified: 2013-10-23
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
Comment
Question by:Andreamary
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39595433
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
 

Author Closing Comment

by:Andreamary
ID: 39595774
Works perfectly...and many thanks for the quick response!
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question