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
|