Looks like the rule is only applied to the first cell, since only the first cell shows the icon with the tick and the cells below show icons without the ticks.
Make sure that the cells have only one conditional format and make sure that the CF is applied to all the cells you are interested in.
I have a separate rule for each line, the picture I posted is just an example of what I did for each line. The tick is unique to the first line, was just playing around with the different icons. I attached my file in the original post if you have some time to take a look
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks