View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claudia Claudia is offline
external usenet poster
 
Posts: 32
Default Link format along with contents of another cell

Say the formula in cell C1 is simply =A1. Is it possible to also link the
format of cell A1 to cell C1 so that if A1 is filled red, C1 will also be
filled red?

The shading in A1 is not based on cell contents so I can't figure out if it
can be done with conditional formatting.