View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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