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
Hello,
If I have a value on one cell "D3"of let's say "2" and in cell F3 a value of let's say "1" then I want cell G3 to say a text, let's say "Good". But if I have in cell D3 a value of "3" and in cell F3 a value of "1" then I want cell G3 to say "Excellent". And if I have in cell D3 a value of 4 and in cell F3 a value of "0" then I want cell G3 to say "Not bad"
Please help
If I have a value on one cell "D3"of let's say "2" and in cell F3 a value of let's say "1" then I want cell G3 to say a text, let's say "Good". But if I have in cell D3 a value of "3" and in cell F3 a value of "1" then I want cell G3 to say "Excellent". And if I have in cell D3 a value of 4 and in cell F3 a value of "0" then I want cell G3 to say "Not bad"
Please help
Related:
- Conditional formatting
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Excel conditional formatting based on date - Guide
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