formating a cell depending of the value of another cell ?

[Romain Jouin]

Dear all,

The "AutoFormat" option on excel 2003 allow to adapt the format of the
cell depending on its own value.
Is it possible to adapt the format of a cell depending on the value of
another cell ?

Thx,
JR.

 

[Dave Peterson]

No.

The closest thing you could do would be to have an event macro that would change
the formatting of the cell.

And the event you used would depend on how that "sending" value changed--by
typing or by calculation.

 

[chris]

You can format the content of one cell based on the value of another
cell using the conditional formatting:
Here I present you an example that will set the back color of cell B1
to red if the content in A1 is 0:
1. Select cell B1
2. From the menubar select format>conditional formatting
3. In the conditional formatting dialog box, select Formula Is from
the left drop down box
4. Enter =$A$1=0 to the textbox on the right
5. Click format button and from pattern tab select red color and click
OK

Hope this helps….


Chris

 

[Dave Peterson]

I was writing about the number format of the cell--not the font, fill, ...
format.

You could use format|conditional formatting for a some formatting basd on the
value of another cell.

Or you could use an event if you have too many rules to apply or formats that
aren't controlled by conditional formatting.