HOW TO FORMAT ANOTHER CELL

K

Kip Price

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!
 
P

Peo Sjoblom

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
 
G

Gary''s Student

click on A1 and:
Format > Conditional formatting... > Formula Is >
=ISTEXT(A1)
 
Top