LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jabi
 
Posts: n/a
Default change format of cells (bold, italic) based on one cell's answer

I want to change the font of cells based on the answer on one cell - similar
to condition formatting, but now the format is based on what one cell reads
e.g. if one cell has a value of 0, then the cells on that row should become
bold, italics, BUT if the value is greater, then they remain constant.

TIA
 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why will my cells not format? Jamie Kelly New Users to Excel 3 January 13th 06 06:41 PM
Creating a conditional format for a cell based on another cell's v steve-o Excel Discussion (Misc queries) 2 October 26th 05 03:51 PM
Conditional Format to change entire row based on one cells data Crowbar via OfficeKB.com Excel Discussion (Misc queries) 2 October 25th 05 04:01 PM
Change the Default Comment Format to NOT be bold kris Excel Discussion (Misc queries) 0 October 6th 05 02:24 PM
how can i create a formula or format the cells so the answer is a. jenniss Excel Discussion (Misc queries) 5 January 6th 05 04:50 PM


All times are GMT +1. The time now is 06:09 AM.

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"