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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 2, 2016 at 01:21 PM
Related:
- Conditional Formatting
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Formatting usb mac - Guide
- Conditional formatting 3 color scale percentages ✓ - Excel Forum
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
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.
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.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 2, 2016 at 01:21 PM
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.
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.
Jun 2, 2016 at 12:05 PM
Jun 2, 2016 at 12:09 PM