HOW TO FORMAT ANOTHER CELL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to set up a formula that will change the format (highlight the
cell) of cell A1 if there is any data (text) in cell C1. Can anyone help me?
Thanks!
 
This will change the fill colour of A1

select A1, do format>conditional formatting, select formula is and use

=$C$1<>""

click the format button and click the patterns tab, then select the colour
of your choice and click OK twice
 
Back
Top