Change cell color on change

A

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
 
C

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
 
J

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

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 *
 
Top