Change color in row to red when the value in A10 equals 0.

[jay211948]

I have a row A1 to A10 containing text and numbers. I want to change all entries in the row to red when the value in A10 equals 0.
Thanks.

 

[etaf]

select A1 to A10
then use a formula
$A$10 = 0

Book6
	A
1	a
2	b
3	c
4	d
5	1
6	2
7	3
8	4
9	5
10	0
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A10	Expression	=$A$10=0	text	NO

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A1:A10 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=$A$10=0

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[jay211948]

Thanks for your response. However, I didn't give you the correct information. I meant to say that the row is A1 to F10. I need to change the color in the row to red when F10 equals 0.

 

[etaf]

change the colour of all the rows 1 to 10 - or just row 10

If all the rows

Then , same sort of thing

select A1 to F10
and then use a formula

Blanks are seen as zero - this stops that
=AND($F$10<>"",$F$10=0)

Book6
	A	B	C	D	E	F
1	a
2	b
3	c
4	d
5	1
6	2
7	3
8	4
9	5
10	0					0
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:F10	Expression	=AND($F$10<>"",$F$10=0)	text	YES

 

[jay211948]

Thanks.

 

[etaf]

you are welcome

 

[Peter_SSs]

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.