Conditional formatting based on format in a different cell

M

Mary Katherine

I want to format the text in cell F5 as BOLD if the text in cell F1 is BOLD.
How can I do this in Excel 2007?
 
O

Otto Moehrbach

You can't use conditional formatting to detect formatting of another cell.
Perhaps you can do so with the condition that drove the F1 format if such is
the case. HTH Otto
 
Top