Change cell color based upon partial cell contents

**msmick** · 01-14-2012, 12:50 AM

Hi,

Thanks for taking the time to help.

Looking for a sub that will look though column of "A" and if a cell contains:

"F D" make text bold and brown (.Color = -16764058)
"F T" make text bold and green (.Color = -16744448)
"F A" make text bold and purple (.Color = -3407719)

**teylyn** · 01-14-2012, 01:08 AM

Hello,

why do you want a macro for that? Excel can do this out of the box with conditional formatting.

Select all cells, starting with A1 and enter three conditional formatting rules: Home ribbon > conditional formatting > new rule > use a formula to determine

First rule:
=FIND("F D",TRIM(A2)) -- brown

second rule
=FIND("F T",TRIM(A2)) -- green

third rule
=FIND("F A",TRIM(A2)) -- purple

cheers,

**msmick** · 01-14-2012, 01:24 AM

Hi Teylyn,

Thanks for the reply.

Maybe in my attempt to keep things simple I oversimplified too much.

The reason I am looking for a sub routine is because it will be inserted as part of a much larger macro that is run on many different files everyday.
The larger macro copies the (soon to be formatted) data from this column elsewhere (to a single cell) on the spreadsheet before deleting this column.

As a stand alone, based on my oversimplified attached spreadsheet, yes your solution does the trick.

Hope this makes things a bit clearer.