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
Related:
- Microsoft Excel Conditional Formatting
- Microsoft excel download - Download - Spreadsheets
- Excel date format dd.mm.yyyy - Guide
- Marksheet format in excel - Guide
- Clear formatting in excel - Guide
- Number to words 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.
