Microsoft Excel Conditional Formatting
Closed
bunnyboy123
Posts
2
Registration date
Wednesday August 12, 2015
Status
Member
Last seen
August 13, 2015
-
Aug 12, 2015 at 02:33 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 13, 2015 at 12:06 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 13, 2015 at 12:06 PM
Hi,
I'm trying to make a cell display a number based whether or not another cell contains the words, "Sentinel", "Ramsden", "Goulding", or "Riverdale".
Thanks,
Bunnyboy
I'm trying to make a cell display a number based whether or not another cell contains the words, "Sentinel", "Ramsden", "Goulding", or "Riverdale".
Thanks,
Bunnyboy
Related:
- Microsoft Excel Conditional Formatting
- Microsoft excel mod apk for pc - Download - Spreadsheets
- How to change date format in excel - Guide
- Marksheet format in excel - Guide
- How to clear formatting in excel - Guide
- Gif in excel - Guide
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 13, 2015 at 08:06 AM
Aug 13, 2015 at 08:06 AM
Bunnyboy, Good morning.
The conditional format works only aesthetic aspects.
As you need a logical answer, the correct is you use the IF FUNCTION.
Example:
A1 has the formula:
= IF(B1 = "Sentinel", 2, IF (B1 = "Ramsden", 5 .... etc.
Please, explaine a little better your necessity.
I believe that many people will arrive to help you.
The conditional format works only aesthetic aspects.
As you need a logical answer, the correct is you use the IF FUNCTION.
Example:
A1 has the formula:
= IF(B1 = "Sentinel", 2, IF (B1 = "Ramsden", 5 .... etc.
Please, explaine a little better your necessity.
I believe that many people will arrive to help you.
bunnyboy123
Posts
2
Registration date
Wednesday August 12, 2015
Status
Member
Last seen
August 13, 2015
Aug 13, 2015 at 11:43 AM
Aug 13, 2015 at 11:43 AM
Thanks that helps a lot. Now the only problem I have is that if it doesn't contain one of those names, I'd like to make it display "0". And also add half of a an adjacent box depending on whether or not a box is TRUE or FALSE
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 13, 2015 at 12:06 PM
Aug 13, 2015 at 12:06 PM
Please, show us your formula to easier our help to you.
I don't understand:
"...And also add half of a an adjacent box depending on whether or not a box is TRUE or FALSE..."
Does it means that you have a number on adjacent box and you want to add half of this number?
Save your file at a free site, www.speedyshare.com e put a link to download here.
Tell us what data you have and what you expect to receive as result.
Put the result manually to show us your necessity.
I don't understand:
"...And also add half of a an adjacent box depending on whether or not a box is TRUE or FALSE..."
Does it means that you have a number on adjacent box and you want to add half of this number?
Save your file at a free site, www.speedyshare.com e put a link to download here.
Tell us what data you have and what you expect to receive as result.
Put the result manually to show us your necessity.
