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
 
click on A1 and:
Format > Conditional formatting... > Formula Is >
=ISTEXT(A1)
 
You must log in or register to reply here.

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

Comparison of columns using Conditional Formatting 3
setting cell values based on a 3rd cell 4
Excel Highlighting duplicates 0
Need Help 4
Link format along with contents of another cell 1
Conditiona format based on format of another cell 1
Excel Typed text appears in wrong cell 0
Excel VBA 1

Back
Top