Is there a worksheet function available to format text? I have a situation
where I need to BOLD a column based on criteria provided in another column.
The file contains 27,000 rows so this is not something I want to do manually.
I understand that I may need to insert a new column and use an IF function
to either BOLD the original column value or copy it as is.

Anyone have any suggestions?

Thanks,

Jim

Formatconditional formatting and formula is

assume the text are in A1:A10 and the criteria range is
C1:C10 and the criteria is 2

select A1:A10 with A1 as the active cell do the formatting and in the
formula box put

=$C12

click the format button and select bold font and click OK twice

replace the range with your ranges and the criteria with your criteria


regards,

Peo Sjoblom

"Jim" wrote:

Is there a worksheet function available to format text? I have a situation
where I need to BOLD a column based on criteria provided in another column.
The file contains 27,000 rows so this is not something I want to do manually.
I understand that I may need to insert a new column and use an IF function
to either BOLD the original column value or copy it as is.

Anyone have any suggestions?

Thanks,

Jim

Your suggestion worked perfectly. I had not used the Conditional Formatting
before. This will meet my needs.

Thanks for your help.

Jim

"Peo Sjoblom" wrote:

Formatconditional formatting and formula is

assume the text are in A1:A10 and the criteria range is
C1:C10 and the criteria is 2

select A1:A10 with A1 as the active cell do the formatting and in the
formula box put

=$C12

click the format button and select bold font and click OK twice

replace the range with your ranges and the criteria with your criteria


regards,

Peo Sjoblom

"Jim" wrote:

Is there a worksheet function available to format text? I have a situation
where I need to BOLD a column based on criteria provided in another column.
The file contains 27,000 rows so this is not something I want to do manually.
I understand that I may need to insert a new column and use an IF function
to either BOLD the original column value or copy it as is.

Anyone have any suggestions?

Thanks,

Jim