Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search For A Column Width in Conditional Formatting
You did not add the second parameter to the cells formula
Try this =CELL("width",A1)<0.8 if it does not work then make sure that Excel has not added anything to the formula above when you entered it in conditional formatting under Formula Is... You must be aware that "the formula gives the width of the cell rounded off to an integer. Each unit of column width is equal to the width of one character in the default font size." "ml" wrote: 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 -- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search For A Column Width in Conditional Formatting
Hi Sheeloo, thanks for your response!
I did try it with the A1, but it still didn't work. Can I not use 0.8? If I put in a different number, from somewhere else in the spreadsheet (like V7 instead of the A1), it will flag a group of merged columns, but not the little columns I'm trying to find. Wish I could post a screen shot, I know I am not helping you much with this description... ML "Sheeloo" wrote: You did not add the second parameter to the cells formula Try this =CELL("width",A1)<0.8 if it does not work then make sure that Excel has not added anything to the formula above when you entered it in conditional formatting under Formula Is... You must be aware that "the formula gives the width of the cell rounded off to an integer. Each unit of column width is equal to the width of one character in the default font size." "ml" wrote: 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 -- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search For A Column Width in Conditional Formatting
Send me the file... Click on my name on the post to see the email address.
-- To get my email id paste my address in an Excel cell and press Enter... "ml" wrote: Hi Sheeloo, thanks for your response! I did try it with the A1, but it still didn't work. Can I not use 0.8? If I put in a different number, from somewhere else in the spreadsheet (like V7 instead of the A1), it will flag a group of merged columns, but not the little columns I'm trying to find. Wish I could post a screen shot, I know I am not helping you much with this description... ML "Sheeloo" wrote: You did not add the second parameter to the cells formula Try this =CELL("width",A1)<0.8 if it does not work then make sure that Excel has not added anything to the formula above when you entered it in conditional formatting under Formula Is... You must be aware that "the formula gives the width of the cell rounded off to an integer. Each unit of column width is equal to the width of one character in the default font size." "ml" wrote: 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 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting with text search | Excel Discussion (Misc queries) | |||
Can I use an OR function with SEARCH in conditional formatting? | Excel Worksheet Functions | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Refer to column width in conditional formatting | Excel Discussion (Misc queries) | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) |