Microsoft Excel Conditional Formatting
Closed
bunnyboy123
Posts
2
Registration date
Wednesday 12 August 2015
Status
Member
Last seen
13 August 2015
-
12 Aug 2015 à 14:33
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 13 Aug 2015 à 12:06
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 13 Aug 2015 à 12:06
Related:
- Microsoft Excel Conditional Formatting
- Excel clear formatting - Guide
- Microsoft excel mod apk - Download - Spreadsheets
- Excel conditional formatting based on date - Guide
- How to change date format in excel - Guide
- Kernel for excel repair - Download - Backup and recovery
3 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
13 Aug 2015 à 08:06
13 Aug 2015 à 08:06
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 12 August 2015
Status
Member
Last seen
13 August 2015
13 Aug 2015 à 11:43
13 Aug 2015 à 11:43
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
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
13 Aug 2015 à 12:06
13 Aug 2015 à 12:06
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.
