#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard
 
Posts: n/a
Default If, then

Here's what I want to do.........if any number in a specified column is a
specified value, I want to highlight the cell or "fill" the background of
that cell with a specified color, and present that number in bold-face. Can
anyone tell me how to do this?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BSantos
 
Posts: n/a
Default If, then

under the formatting menu there is conditioning formatting and you can put
multi conditions from bold to color background.

B.

"Richard" wrote:

Here's what I want to do.........if any number in a specified column is a
specified value, I want to highlight the cell or "fill" the background of
that cell with a specified color, and present that number in bold-face. Can
anyone tell me how to do this?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default If, then

Look up conditional formatting in help.

--

HTH

RP

"Richard" wrote in message
...
Here's what I want to do.........if any number in a specified column is

a
specified value, I want to highlight the cell or "fill" the background of
that cell with a specified color, and present that number in bold-face.

Can
anyone tell me how to do this?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"