Color coding cells

  • Thread starter Thread starter JayDee
  • Start date Start date
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.
 
Use the format painter (looks like a little yellow paint brush) icon on your
toolbar. If you don't have it, add
 
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
 
Back
Top