Conditional Formatting
Closed
Pawan
-
2 Jun 2016 à 09:55
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 2 Jun 2016 à 13:21
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 2 Jun 2016 à 13:21
Related:
- Conditional Formatting
- Excel conditional formatting based on date - Guide
- How to clear formatting in excel - Guide
- Formatting windows 7 - Guide
- Hp formatting tool - Download - Storage
- Formatting sd card to fat32 - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
2 Jun 2016 à 11:47
2 Jun 2016 à 11:47
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 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
2 Jun 2016 à 13:21
2 Jun 2016 à 13:21
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.
2 Jun 2016 à 12:05
2 Jun 2016 à 12:09