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 --

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 --

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 --

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 --