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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Dave Proctor" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

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

On Sun, 16 Sep 2007 04:17:03 +1000, Dave Proctor
<(E-Mail Removed)> wrote:

>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

On Sat, 15 Sep 2007 11:24:40 -0700, Gord Dibben <gorddibbATshawDOTca>
wrote:

>See help on Conditional Formatting.
>
>You can change font style and background color depending upon the value in a
>cell.

Exactly what I was after - ta muchly.

Dave