If condition-1 in supporting column like column 1 to 10 .one if condition-2 and from 11 to etc. U can still go for nested if condition in the supporting column which are on wright side of u r table ,and update the Conditional format "=>1", Color or leave it.
Punnam
Bookmarks