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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Conditional Formatting Removal 7
Conditional Formatting in Excel 2007 1
copy conditional formatting range 3
Conditional Formatting based on Text 2
Unable to obtain relative reference using conditional formatting 2
bold text of referenced cell show in formula cell 1
I want to conditionally format an entire column after 1 year from 1
Need help with macro for conditional formatting using number forma 1

Top