linking cells and formatting

  • Thread starter Thread starter pierre
  • Start date Start date
P

pierre

i have made cell A1 in font color red and i filled it in yellow color.
what should do now in order to link cell B1 to A1 whith the same criteria ??

please help
 
If you have manually filled and coloured A1, then a formula cannot
bring that formatting across to B1.

However, if the colours are as a result of Conditional Formatting
applied to A1, then the same criteria can be applied to cell B1 to get
the same effect.

Hope this helps.

Pete
 

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

Conditional Formatting 3
protect cell format 1
Conditional Formating based on Date 5
Change Color of cell 3
Apply color of one cell to other 2
How do I use cond format formula to set cell text and color? 4
Excel 2007: cell shading (not conditional formatting) 1
Flashing Cell 6

Back
Top