Condition formatting multiple cells with color

[rob36]

Hello,

I have a program currently set up where operators enter in information into 5 cells. If possible, I would like to have it so that if an operator enters in information into H6 for example, then F6,G6, H6, I6 and J6 will all light up green.

Currently I ahve my conditional formatting set up so it says

=($H$6="OUT")

it then applies a green fill as a result, and I have it set so it applies to: =$F$6:$J$6

This works fine for that cell. I would like to get it so that it not only works for H6, but also if I were to have H7 column say OUT, then it would highlight it green for F7, G7, H7, I7 and J7 (and so on, ideally for about 20 rows)

Is this possible to do in a single conditional format, or do I need to do a different conditional format for each row (That would be kind of a pain)

Essentially, it would need to be something like instead of row 6, the row becomes a wildcard or something would be how I would guess to try and handle it.

 

[Jonmo1]

Change the formula from
=($H$6="OUT")
to
=($H6="OUT")

Then you can copy F6:J6, and paste special - formats to the rest of the rows.
Or just change the applies to range to $F$6:$J$(whatever row)

Hope that helps.

 

[rob36]

thank you, that appears to do what I want

if I want it to not only apply to H6 = out, but say M6 = Out, could I remove the $ before $H6= "OUT" in my formula to make it work? I tried that and I don't think it was giving me the results I expected.

 

[Jonmo1]

For that you would use OR in the formula

=OR($H6="OUT",$M6="Out")