Conditional formating

  • Thread starter Thread starter Garyp1961
  • Start date Start date
G

Garyp1961

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.
 
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.
 
Thank You very much. It worked perfect....

T. Valko said:
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





.
 
Back
Top