Conditional Formatting

Closed
Pawan - Jun 2, 2016 at 09:55 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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.
OK! So what do I use to change the content of the cell?
Meaning how do I get one cell to change based on the info entered in another cell?
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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.