Hi all,
I am having an issue with conditional formatting. I need to check if the percentages is below 87% or over 113% and if they are they are highlighted in red. I got that covered but now I need to check if the criteria occurs consecutively for 2 months and if so i need to highlight the corresponding fruit in red as well.
is there a way to do it?
here is a sample with my condition in it.
Thanks in advance.
conditional formatting sample.xlsx
Bookmarks