Please help with cell..

R

Razak

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.
 
M

muddan madhu

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help Please quick question 7
Can RGB fill color be automated based on 3 cell values? 2
How to filter rows data based on background color of individual cells 1
Conditional formatting 3
Cond. formatting, based on other cell values? 3
How do I format a cell based on the contents of a different cell? 1
Conditional Colors in a CELL 1
How To Have A Cell Be Blank If... 2

Top