Color coding cells

J

JayDee

Is it possible to format cell A1 to display the same color as the color
hi-lighted in cell A14? There is no text in cell A14, only a color.
 
D

Don Guillett

Use the format painter (looks like a little yellow paint brush) icon on your
toolbar. If you don't have it, add
 
O

Otto Moehrbach

No, a formula will not do that. If the color in A14 is driven by some
condition in the file or sheet, you may be able to use Conditional
Formatting in cell A1 to get that color, otherwise you will have to use VBA.
Post back with more info. 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

Format text color 4
conditional Formatting cell wildcard 3
How to extract separated text by many commas in Excel? 0
How do I find a dash in a cell with numbers in it in excel. 9
Linked Named Ranges 2
Change different cell based on conditional statement 4
Excel VBA 1
Excel VBA - Problem with Closing Print Preview 0

Top