Formulas to insert a word and change the cell a different color

[jbarnwell]

Looking for help on the formula to use if I wanted a specific cell to change color to red AND have the word 'Report' if there was a value in a different cell above it. The cell I want formatted has the word 'Report' in it in the photo and the cell I want it to be based off of is above it (2).

 

[jtakw]

Hi,

Do you mean this:

Book3.xlsx
	A	B
1
2
3		1
4		1
5		0
6		2
7		Report
Sheet983

Cell Formulas
Range	Formula
B7	B7	=IF(B6="","","Report")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B7	Expression	=B7<>""	text	NO

 

[jbarnwell]

This is awesome! thank you!

 

[jtakw]

You're welcome, thanks for the feedback.

 

[jbarnwell]

Hold up, I didn't explain it fully, if the cell contains no value then I don't need it to show the word 'Report'

 

[jtakw]

It Won't.

If B6 is blank, B7 stays blank and Won't get highlighted.

 

[jbarnwell]

Hello, I've attached two photos, both have the formula you have provided to me. It looks as though regardless of whether cell 9B has a summed number in it or its summed to zero, the word 'Report' remains. I only want the word to show if there is a summed value greater than zero.

 

[jtakw]

Hello, I've attached two photos, both have the formula you have provided to me. It looks as though regardless of whether cell 9B has a summed number in it or its summed to zero, the word 'Report' remains. I only want the word to show if there is a summed value greater than zero.

That is Not what you said in OP!
You have a Hyphen in B6, therefore it's not considered Blank.

Try this:

Book3.xlsx
	B
1
2
3
4
5
6	1
7	1
8	0
9	2
10	Report
Sheet974

Cell Formulas
Range	Formula
B10	B10	=IF(N(B9),"Report","")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B10	Expression	=N(B9)	text	NO

 

[jbarnwell]

that worked! thank you!

 

[jtakw]

You're welcome.