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
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Phone formatting software for pc - Download - File management
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