Change cell color on change

  • Thread starter Thread starter adel
  • Start date Start date
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
 
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
 
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
 
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 *
 
Back
Top