Font color

  • Thread starter Thread starter daniel chen
  • Start date Start date
D

daniel chen

I am monitoring about 100 stocks. Their tickers are listed in column(A).
In column(B), right next to the ticker, they are sorted into 3 catagories:
Buy,Hold,Sell.
I would like to make the font color of the tickers in column(A) to reflect
what is in column(B).
Green ticker fonts(ColorIndex = 50) for Buy, Yellow(ColorIndex = 45) for
Hold and Red(ColorIndex = 3) for Sell.
Any help would be appreciated.
 
Hi Daniel!

Use Conditional Formatting

Select the range with Buy, Sell, Hold
Format > Conditional Formatting
Cell Value Is
Equal to
="Buy"
Format button
Select font color
OK
Add button
etc.

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Norman!
That would change the font color of Buy,Hold,Sell.
But I like to change the font color of tickers in column(A).
Is it possible?
 
Hi Daniel!

To change the Ticker font colour you'd need to use the same conditional
formatting but this time use the following on the selected range in A.

Formula Is

=B1="Buy"

You can format the font of all entries in a row based on the entry in B by
selecting the table and using

Formula Is:

=$B1="Buy"

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Norman!
I got it right. Thank you much.

Norman Harker said:
Hi Daniel!

To change the Ticker font colour you'd need to use the same conditional
formatting but this time use the following on the selected range in A.

Formula Is

=B1="Buy"

You can format the font of all entries in a row based on the entry in B by
selecting the table and using

Formula Is:

=$B1="Buy"

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
Hi Daniel!

Thanks for thanks is always appreciated and shows Google searchers
that a solution works (or doesn't :( )

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top