Conditional Formatting

Closed
Pawan - Jun 2, 2016 at 09:55 AM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Jun 2, 2016 at 01:21 PM
Hello,

Can someone help in figuring out a formula. If in the spreadsheet I enter under the condition column "good" or "bad" I need the next column under replacement to automatically be showing "Yes" or "No" depending on what I type in condition column. Also the Price column to show the amount if the replacement column has "yes"

Sorry for any confusion

2 replies

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Jun 2, 2016 at 11:47 AM
Pawan, Good morning.

As the name says, Conditional Formatting only changes the FORMAT of a cell, not the content.
It works the aesthetic aspect of the cell.

About your case you need a formula:

Suppose:
Condition column = A
Next column = B

B1 --> =IF(A1="good","YES",IF(A1="bad","NO",""))

Please, give us some more info about layout of your file to help you better.

Is this what you want?
I hope it helps.
0
OK! So what do I use to change the content of the cell?
0
Meaning how do I get one cell to change based on the info entered in another cell?
0
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Jun 2, 2016 at 01:21 PM
Pawan,

Sorry but I can´t understand exactly what you want.

The formula I gave you changes the content of B1 cell depending on value at A1.

Please, show us a real example to easier the answers.

If you prefer save your file at a free site, www.speedyshare.com and put a link to download here.
0