Microsoft Excel Conditional Formatting

[Closed]
Report
Posts
2
Registration date
Wednesday August 12, 2015
Status
Member
Last seen
August 13, 2015
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
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

3 replies

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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.
Posts
2
Registration date
Wednesday August 12, 2015
Status
Member
Last seen
August 13, 2015

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
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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.