I am a bit puzzled. I have conditionally formatted the cells as shown in the screenshot. I have autofilters on the columns. I set it to filter green. The majority of the cells shown are green, but there are a couple of red... I tried the turn on - turn off if true checkboxes and it doesn't seem to make a difference. Any ideas? I really thought this would be simple. The workbook is set to manually calculate. Thanks in advance.
Capture.PNG
Bookmarks