coloring font

  • Thread starter Thread starter kubimaibam
  • Start date Start date
K

kubimaibam

Dear all,
I want to format a cell based on the value of anothe
cell. For example, I want the color of the text in one cell to be re
if the value in another cell is "Y". How could I acheive this.

Please advice
 
Hi kubimaibam!

Assuming the cell that governs format is A1:

Select the cell
Format > Conditional Format
First drop down select "Formula is"
Type: =A1="Y"
Format
Select your choice of format
OK
OK

Note here that I've used relative referencing for A1 if you choose to
copy
Note also that the Y has to be in quotation marks or Excel will start
looking for a cell named Y


--
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.
 
Thanks Norman Harker MVP (Excel) Sydney, Australia for your kind
information and it is working fine.
 
Back
Top