Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
conditional formating - Help | Excel Worksheet Functions | |||
Conditional Formating | Charts and Charting in Excel | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
conditional formating.... | Excel Worksheet Functions |