Bolding/etc based on formula results...

  • Thread starter Thread starter Dave Proctor
  • Start date Start date
D

Dave Proctor

Hi folks,

I want to insert a formula into a cell, whereby if the results were
outside a certain range, the results would be bolded, and the cell
possibly infilled with a different background colour.

If the results of the formula fell within the certain range, then the
results would appear as normal type, and the background colour would
be the same as the rest of the spreadsheet.

Any pointers on how I can do this?

Cheers,

Dave
 
A formula cannot change a cell's format
But Format | Conditional Formatting can do just what you want.
Have a look at it, experiment, then return with questions.
best wishes
 
See help on Conditional Formatting.

You can change font style and background color depending upon the value in a
cell.


Gord Dibben MS Excel MVP
 
See help on Conditional Formatting.

You can change font style and background color depending upon the value in a
cell.
Click to expand...

Exactly what I was after - ta muchly.

Dave
 
Back
Top