Formatting text....

[Guest]

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

 

[Guest]

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

=$C1>2

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

 

[Guest]

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

Thanks for your help.

Jim