Highlighting a row and the one below it

[Jon_London]

Hi there everyone

I'm stuck on a highlighting issue and wonder if someone could please help.

I have a spreadsheet containing around 180,000 rows, some of which have the number 2 in column H. What I'm trying to achieve is to highlight the all rows in some way that contain the number in H, but also highlight the row below those rows.

So, if Row 1500 contains 2 in column H, then I'd like to highlight both Row 1500 and 1501.

Many thanks for your help.

Jon

 

[Joe4]

You should be able to use Conditional Formatting on it.
Highlight row 1 and enter this CF formula:
=$H1=2
and choose your highlighting color choice

Then choose the rest of the rows (starting with row 2) and use this CF formula
=OR($H2=2,$H1=2)
and choose your highlighting color choice

 

[Scott T]

You can use conditional formatting to do this.
Select the cells you want to format

In conditions formatting select new rule
then select use formula to determine which cells to format
use this formula

=OR($H2=2,$H1=2)

Select your formatting.

If this starts in row 1 with no headers then when you do the above do not select row one instead make a different rule for row 1 and use

=H1=2

 

[Joe4]

If this starts in row 1 with no headers then when you do the above do not select row one instead make a different rule for row 1 and use
Code:
=H1=2

We are both saying the same thing, but just note that if you want to highlight the whole row, you will need a "$" in front of the "H" (like I showed in my reply and you showed in your other rule).

 

[Scott T]

DOH! did not even notice that I forgot to lock the column

 

[Jon_London]

Fantastic, thanks everyone!