Conditional formatting
Closed
KingFloyd
Posts
2
Registration date
Tuesday August 1, 2017
Status
Member
Last seen
August 1, 2017
-
Aug 1, 2017 at 04:03 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 1, 2017 at 08:21 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 1, 2017 at 08:21 AM
Related:
- Conditional formatting
- How to clear formatting in excel - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- 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
- 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
Aug 1, 2017 at 07:47 AM
Aug 1, 2017 at 07:47 AM
KingFloyd, Good morning.
What you need does not refer to conditional formatting.
Conditional formatting serves to change aesthetic aspects.
It can be solved simply with a sequence of the nested IF functions.
Try to use:
G3 --> =IF(AND(D3=2, F3=1), "Good",IF(AND(D3=3, F3=1), "Excellent", IF(AND(D4=2, F3=0), "Not bad", "")))
Was that what you wanted?
I hope I have helped you.
What you need does not refer to conditional formatting.
Conditional formatting serves to change aesthetic aspects.
It can be solved simply with a sequence of the nested IF functions.
Try to use:
G3 --> =IF(AND(D3=2, F3=1), "Good",IF(AND(D3=3, F3=1), "Excellent", IF(AND(D4=2, F3=0), "Not bad", "")))
Was that what you wanted?
I hope I have helped you.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 1, 2017 at 08:21 AM
Aug 1, 2017 at 08:21 AM
KingFloyd,
Please, take a look at this little example I did for you.
https://www.sendspace.com/file/f95ikj
Tell us if it worked as you wanted.
Please, take a look at this little example I did for you.
https://www.sendspace.com/file/f95ikj
Tell us if it worked as you wanted.
Aug 1, 2017 at 08:00 AM