Auto formatting in MS-Excel 1

[yimitz]

Is it possible to have excel change the format of one cell based on what you enter in another cell? Say I wanted to automatically have excel format bold fonts if I enter a number in an adjacent cell greater than 100 as an example.

 

[DaleWatson123321]

I'd recommend using Conditional Formatting.

Regards, Dale Watson

 

[DaleWatson123321]

Here's are steps to use:

1) In cell A1 for example, activate Conditional Formatting. From the Menu - Format - Conditional Formatting.

2) Change "Cell is" to "Formula is"

3) For the formula, use =B1>100

4) Choose "Format", then "Font", then "Bold.

5) Click "OK" twice, and you're done.

Regards, Dale Watson