LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ML ML is offline
external usenet poster
 
Posts: 57
Default Search For A Column Width in Conditional Formatting

I am unskilled in Excel macros & am attempting to add a background color to
all columns in a spreadsheet under the width of .8. (Ver. 2007)

What I have tried & is not working:

Select entire worksheet, Conditional Formatting, add a new rule to
Conditional Formatting Rules Manager.

=CELL("width")<0.8

Formatted as Text with a color.

Please, please, any hints as to what I am doing wrong ??? Many thanks in
advance --



 
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
Conditional formatting with text search Ed Excel Discussion (Misc queries) 7 September 24th 08 05:38 PM
Can I use an OR function with SEARCH in conditional formatting? RAYCV Excel Worksheet Functions 3 September 23rd 08 06:46 PM
Formatting cells in a column with conditional formatting? shamor Excel Discussion (Misc queries) 8 May 19th 08 10:11 PM
Refer to column width in conditional formatting sammy Excel Discussion (Misc queries) 4 September 7th 07 02:43 AM
How to make cell width different than the column width it lies in John Excel Discussion (Misc queries) 2 September 11th 06 10:41 PM


All times are GMT +1. The time now is 04:56 AM.

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

About Us

"It's about Microsoft Excel"