More conditional formatting

  • Thread starter Thread starter mcr1
  • Start date Start date
M

mcr1

In cell a3 I want to format it so if there is data, any data whatsoeve
in cell a1, the number in cell a2 will come over in to cell a3. If n
data in a1, I want a3 to be left blank. Any suggestions?

Thanks

Miles Ree
 
Hi

you'll need to use a formula as conditional formatting only changes
formatting (font colours / borders / fill colours not data)

in A3 type
=IF(A1<>"",A2,"")

which means if there is "not nothing" in A1 put the value of A2 into A3,
otherwise leave A3 blank.

Cheers
JulieD
 
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

Continuous Invoice Nos. 3
Change Color of cell 3
Conditional Printing 2
I need a formula for if cells a1 and a2 are the same then cell a3 3
Combining Text From Cells 3
matching cell formula 1
excel formula 1
Formula to find the last number of a column (lower cell) 1

Back
Top