Conditional formatting based on format in a different cell
 

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?

Conditional formatting based on format in a different cell
 

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

"Mary Katherine" wrote in message
...
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?