Hi,
Have a look at the formatting in the attached file. It uses an IF statement to put a number in cell A3 (0 means no data in M/N/O/P3, up to 4 means data in all of them), which then is turned into a data bar. The formatting is repeated in rows 5/7/9/11 so you can see each result.
Attachment 408221
Unfortunately, at the moment I can't see any way to do this in cell A3 of your worksheet, as there's already an IF statement there. Maybe a small column adjacent to it?
I'll have a think and see if I can come up with something better, but hopefully the above helps a bit.
Regards,
Aardigspook
If your problem is solved, please go to 'Thread Tools' on your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.
Bookmarks