Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help with cell..
I have 4 or 5 cell. From that said cell I need to put an "x" and "check"
marked in every cell that will automatically put a word "Confirmed" in another worksheet. would that be possible? Also, the fill-in color.. let say, if its "x" its blue and if its "check" its green. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help with cell..
sheet 1 u need put x or check and sheet 2 u need the answer
use this =IF(OR(sheet1!A1="X",sheet1!A1="check"),"Confirmed ","") To fill color go to format | conditional format | choose formula =$A$1="X" | choose format ( blue color ) | second condition =$A$1="check" | choose format ( green color) | ok | ok On Dec 7, 11:28*am, Razak wrote: I have 4 or 5 cell. From that said cell I need to put an "x" and "check" marked in every cell that will automatically put a word "Confirmed" in another worksheet. would that be possible? Also, the fill-in color.. let say, if its "x" its blue and if its "check" its green. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |