View Single Post
 
Old 03-20-2017, 07:13 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I was able to do something with conditional formatting although it does not highlight the last cell. If there are two in a row, it highlights just the first cell. If there are three in a row, it highlights the first two.

Anyhoo, select the entire range of data. In conditional formatting, go to New Rule, and Use Formula...

Use this formula... =AND(A$2<90,B$2<90)

Set the format you want.
Reply With Quote