coloring font

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
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
K

kubimaibam

Thanks Norman Harker MVP (Excel) Sydney, Australia for your kind
information and it is working fine.
 
Top