Originally Posted by p45cal
I'd like you to tell me:
1. Which 3 or more cells contain the negative values to get that R result in just that one cell AB17
AB17 is month JAN, and cell Q1 is the only JAN to indicate with. its unable to compare 3 or not to indicate R. with one cell only, shld be either R or G
2. Which cells should just that cell AB17 examine to see if they are negative or not.
as mentioned above AB17 is JAN, from Col C - Col V, only Col Q is JAN, so shld be either R or G