Change cell color on change

[adel]

I'm looking to change the font color and style of one cell when anothe
cell has changed text. ( A1 = blue /regular text when cell A12 has th
word closed entered, i'd like to see A1= red/bold

 

[Chip Pearson]

Adel,

You can use Conditional Formatting (CF), from the Format menu, to do this.
Open the CF dialog, and change "Cell Value Is" to "Formula Is" and enter the
formula

=(A1="Closed")

and then click the Format button and choose the font format you want. This
format will be applied to the cell when the value of A1 is "closed".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Jason Morin]

1. Select A1.
2. Format > Conditional Formatting > Formula Is and insert:
=COUNTIF($A$12,"*closed*")
3. Click the Format button and format as desired.

HTH
Jason
Atlanta, GA

 

[A.W.J. Ales]

Adel,

Use (whise cell A1 is the active cell) : Format / Conditioal Formatting.
In de Dropdownbox of condition 1 select : Formula is and in the text box
after that fill in : =A12="closed".

Then in the box below that you can select the formatting of cell A1 in case
the condition ( "closed" in cell A12) is fulfilled.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *