Conditional Formatting Question

[montanaaggie]

I would like the following to happen in the row (B8:K8)

If H8 or J8 is populated the entire row will be highlighted. I know to highlight the entire row, how to select the color, but I'm not certain what the equation needs to be. Can someone please help?

Thanks,
Dave

 

[GlennUK]

Try

=OR(H8<>"",J8<>"")

 

[montanaaggie]

This doesn't appear to have solved the problem entirely. For whatever reason it only highlights a couple cells instead of the entire row. Is there something else I need to do? Does the equation need to be modified?

Thanks,
Dave

 

[montanaaggie]

Nevermind, I forgot to add "$" to the values. This works great.

Regards,
Dave

 

[GlennUK]

Just realised I'd forgotten the $ myself! Glad that's working now.