Hello all,

I have a few different cells in my Excel spreadsheet that I want to always
be bold or shaded red no matter what is in these cells. I have some data
that I sort and always want the top to be bold and shaded red. And of course
when I sort the data and the top data that was bold and red is no longer at
the top, I no longer want it to be bold and red.

How can I make sure these are always bold and red if the data within these
cells keeps moving in and out of them when I sort the data?


Thanks in advance.

One way:

Select the top cells. Choose Format/Conditional Formatting...

CF1: Formula is =TRUE
Format1: <font:bold>/<pattern:shaded>

In article <iNUHi.54316$(E-Mail Removed)>,
"FISH" <(E-Mail Removed)> wrote:

> Hello all,
>
> I have a few different cells in my Excel spreadsheet that I want to always
> be bold or shaded red no matter what is in these cells. I have some data
> that I sort and always want the top to be bold and shaded red. And of course
> when I sort the data and the top data that was bold and red is no longer at
> the top, I no longer want it to be bold and red.
>
> How can I make sure these are always bold and red if the data within these
> cells keeps moving in and out of them when I sort the data?
>
>
> Thanks in advance.

Thanks, that did the trick.


"JE McGimpsey" <(E-Mail Removed)> wrote in message
news:jemcgimpsey-(E-Mail Removed)...
> One way:
>
> Select the top cells. Choose Format/Conditional Formatting...
>
> CF1: Formula is =TRUE
> Format1: <font:bold>/<pattern:shaded>
>
> In article <iNUHi.54316$(E-Mail Removed)>,
> "FISH" <(E-Mail Removed)> wrote:
>
>> Hello all,
>>
>> I have a few different cells in my Excel spreadsheet that I want to
>> always
>> be bold or shaded red no matter what is in these cells. I have some data
>> that I sort and always want the top to be bold and shaded red. And of
>> course
>> when I sort the data and the top data that was bold and red is no longer
>> at
>> the top, I no longer want it to be bold and red.
>>
>> How can I make sure these are always bold and red if the data within
>> these
>> cells keeps moving in and out of them when I sort the data?
>>
>>
>> Thanks in advance.