Aug 15 2019 08:54 AM
Aug 15 2019 09:13 AM
You may use conditional formatting rule with the formula used relative reference on previous column. Let say your range is in columns B:G and you'd like to highlight values which are greater than ones in previous column. When rule formula will be
=B1>A1
and the rule applied to the range $B:$G
Aug 15 2019 09:24 AM
Aug 15 2019 09:42 AM
Select you range and apply CF rule using formula for the top left cell of the range. It will be applied to entire range automatically. However, you may always correct it.
Please check in attached.
Aug 15 2019 09:51 AM
Aug 15 2019 10:11 AM
@oconnells , great, glad to know you sorted this out. Good luck with your project.