Condition formatting question.

[ipbr21054]

Hi,
I would like to have certain text that I’ve selected from a drop down list certain font colours.
Example.
In the drop down list say I have Dog Cat Fish selections.
When I select Dog from the list the font will be Red when Dog is then shown in that cell.

Over time I will be able to look down the column and see all Dog in Red Cat in yelllw etc.

Is condition formatting the way to do this or vba ?

 

[jtakw]

Hi,

In the cell(s) where you have your drop down list, use the following formulas for Conditional Formatting, change cell reference to suit:

=A1="Dog" (CF for red)
=A1="Cat" (CF for yellow)
etc.

 

[ipbr21054]

Hi
can you explain a little more please.

 

[jtakw]

First off, how many colors do you plan to have formatted for the values in the cells?
Because CF is limited to 3 Formatting rules, 4 if you include the cell formatting.

 

[ipbr21054]

Would need to check tomorrow but at a guess 10

 

[jtakw]

OK, if it's more than 4, then you'll probably need to do this with VBA, check this post:

https://www.mrexcel.com/forum/excel...ber-conditional-format-rules-can-applied.html

Follow the link in Post #6 for VBA code to do more than 3 CF rules.

 

[ipbr21054]

Many thanks,i will take a look.