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.