Thread: [Solved] Conditional formating
View Single Post
 
Old 12-01-2016, 10:37 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

How about this? I formatted all your concatenated data cells to text. I also copy and pasted text only all your data because it was looking for a file on your desktop to get data from. So just look at the conditional formatting and replicate on your sheet if you it suits your needs.

Basically, the conditional format equation is:

Code:
=LEFT(H4,1)+RIGHT(H4,1)>$D4
Of course, this will only work if you only have single digit concatenation. If that assumption is not valid, then we can modify the equation to account for it:

Code:
=LEFT(H4,FIND("/",H4)-1)+RIGHT(H4,LEN(H4)-FIND("/",H4))>$D4
Attached Files
File Type: xlsx Sample.xlsx (16.1 KB, 8 views)
Reply With Quote