Format a cell based on values in that row

[ghladik]

Column B contains the individual cells I want to color if there is a "2" anywhere in each of those cells rows. For instance, if row 20 has a series of numbers, but not the number "2", I don't want it colored. If row 21 does have a cell in that row with the number "2", I do want it colored.

I attached a photo illustrating this. My problem is I can't find a way to set the conditional formatting in bulk. I can do it if I want to duplicate the rule 5 million times, 1 per row.

Any help is appreciated!

[Jonmo1]

You almost have it..

The formula should be written relative to the Active Cell.
The active cell is currently A239 as shown in the name Box at the top left.

And the formula should only refer to that single row, not the entire range of rows. You set the "refers to range" to the entire range..
And finally, the "2" should be just 2 <- no quotes.

Try

=COUNTIF($F239:$OA239,2)


Oh, and an actual Excel Document attachment is preferred over pictures...

[ghladik]

Thanks for this- so how would I duplicate this rule to highlight any of the cells in column B whose row contains a 2 without doing it 1 by 1?

What my end goal is to try to find and highlight any row that has a discrepancy (the #2) and highlight the cell for that row.

[Jonmo1]

Highlight the ENTIRE Range first....
Then go to conditional formatting
Write the formula relative to the activecell shown in the Name Box
But the formula still only refers to that 1 row.
It will automatically incriment the row # among all the rows you selected first.

[ghladik]

Perfect- thanks for your help.

[Jonmo1]

You're welcome.