Highlight a row in excel

[MiteshG]

Hi - I have an excel sheet which has numerical data in columns J through AV. I would like to highlight rows where all columns have data as either 0 or blank. How do I achieve it through either conditional formatting or formula? Example below - (In this, I would like to highlight row 2). Thanks in advance for your help

10	0
0		0

 

[Joe4]

You can use Conditional Formatting to do that.

Let's say that you wanted to do this to rows 3:100. Then do the following:

1. Select the rows 3:100
2. Go to Conditional Formatting, and select the "Use a formula to determine which cells to format" option
3. Enter the following formula:

=COUNTIF($J3:$AV3,0)+COUNTIF($J3:$AV3,"")=39

4. Choose your desired formatting option
5. Click OK

This should do what you want.

 

[MiteshG]

You can use Conditional Formatting to do that.

Let's say that you wanted to do this to rows 3:100. Then do the following:

1. Select the rows 3:100
2. Go to Conditional Formatting, and select the "Use a formula to determine which cells to format" option
3. Enter the following formula:

=COUNTIF($J3:$AV3,0)+COUNTIF($J3:$AV3,"")=39

4. Choose your desired formatting option
5. Click OK

This should do what you want.

Thank you so much for your response. If I may ask, what does the "=39" mean here in the formula?

 

[MiteshG]

Thank you so much for your response. If I may ask, what does the "=39" mean here in the formula?

Ah - I think I got it. It's the number of columns from J to AV. Thanks again for the help.

 

[Joe4]

You are welcome.
Glad I was able to help!