coloring font

[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

 

[J.E. McGimpsey]

Take a look at Conditional Formatting in XL Help.

 

[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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[kubimaibam]

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