More conditional formatting

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
 
J

JulieD

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
 
Top