Conditional format

[julievandermeulen]

4​
6​		Strawberry
2​
1​		strawberry
13​

I'm looking to highlight A2 and A4 because the word "Strawberry" is in C2 and C4, (regardless of whether it's Capitalized or not), and put the total in cell B6.

Is that possible and how would I do it? Can I do it with conditional formatting or do I need to put a formula in B6 and Conditional format column A separately.

 

[Eric W]

Try:

Book1
	A	B	C
1	4
2	6		Strawberry
3	2
4	1		strawberry
5	13
6		7
Sheet15

Cell Formulas
Range	Formula
B6	B6	=SUMIF(C1:C5,"strawberry",A1:A5)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A5	Expression	=$C1="Strawberry"	text	NO

 

[julievandermeulen]

Try:

Book1
	A	B	C
1	4
2	6		Strawberry
3	2
4	1		strawberry
5	13
6		7
Sheet15

Cell Formulas
Range	Formula
B6	B6	=SUMIF(C1:C5,"strawberry",A1:A5)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A5	Expression	=$C1="Strawberry"	text	NO

Is it possible to do it in one step with just conditional formatting?

 

[Eric W]

Sorry, no. As the name indicates, "Conditional Formatting" just changes the formatting. If you want a value displayed on the sheet, you need a regular formula.

 

[julievandermeulen]

Sorry, no. As the name indicates, "Conditional Formatting" just changes the formatting. If you want a value displayed on the sheet, you need a regular formula.

ok thank you