Conditional formating
 

Hello All,
I would like to know how to format a cell where it will give me the number 1
when I enter any type of data in a different cell. Example I enter data in
cell a1 and I would like for my formatted cell say it's c4 to show the number
1
Thanks for any help in advance.

Conditional formating
 

You don't want conditional formatting, you want a formula.

Enter this formula in C4:

=IF(A1="","",1)

What that means in plain English:

If cell A1 is blank/empty, leave cell C4 blank. If cell A1 is not
blank/empty return the number 1 to cell C4.

--
Biff
Microsoft Excel MVP


"Garyp1961" wrote in message
...
Hello All,
I would like to know how to format a cell where it will give me the number
1
when I enter any type of data in a different cell. Example I enter data
in
cell a1 and I would like for my formatted cell say it's c4 to show the
number
1
Thanks for any help in advance.

Conditional formating
 

Thank You very much. It worked perfect....

"T. Valko" wrote:

You don't want conditional formatting, you want a formula.

Enter this formula in C4:

=IF(A1="","",1)

What that means in plain English:

If cell A1 is blank/empty, leave cell C4 blank. If cell A1 is not
blank/empty return the number 1 to cell C4.

--
Biff
Microsoft Excel MVP


"Garyp1961" wrote in message
...
Hello All,
I would like to know how to format a cell where it will give me the number
1
when I enter any type of data in a different cell. Example I enter data
in
cell a1 and I would like for my formatted cell say it's c4 to show the
number
1
Thanks for any help in advance.



.

Conditional formating
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Garyp1961" wrote in message
...
Thank You very much. It worked perfect....

"T. Valko" wrote:

You don't want conditional formatting, you want a formula.

Enter this formula in C4:

=IF(A1="","",1)

What that means in plain English:

If cell A1 is blank/empty, leave cell C4 blank. If cell A1 is not
blank/empty return the number 1 to cell C4.

--
Biff
Microsoft Excel MVP


"Garyp1961" wrote in message
...
Hello All,
I would like to know how to format a cell where it will give me the
number
1
when I enter any type of data in a different cell. Example I enter
data
in
cell a1 and I would like for my formatted cell say it's c4 to show the
number
1
Thanks for any help in advance.



.