Conditional Format two consecutive cells greater than a set target

[andrewedwards]

Hi all, first post so please excuse me if this has been answered elsewhere on the site. What I am trying to do is highlight two consecutive cells when they are above a set target in red for example, but also highlight other months in orange that are also above the target but not consecutively. I have added a simple example below of what I am trying to achieve.

Example:
Target = 25 seconds
The average speed at which a call should be answered is 25 seconds and I want it to highlight when two months in a row exceed this target.
A B C D E F G H
January February March April May June July Aug
18sec 24sec 28sec 29sec 24sec 21sec 26sec 21sec

With the above I would like March and April to be in Red and also July in orange.

Hope this is clear and any help is really appreciated.

[ragulduy]

Could you upload an example workbook showing your data?

Is the value of the cell A1
"18sec" or "18" with formatting for the sec.

Assuming you have number values and you are looking at row 1, you could highlight B1:H1 and then with B1 active put the formulas:
=AND(D1>25,OR(C1>25,E1>25))
and
=D1>25
as your conditional format formulas and then assign one to red and one to orange.
For A1 you will need to use the formula:
=AND(A1>25,B1>25)
as you can't refer to the cell to the left of A1...

[andrewedwards]

Hi thanks for the reply,

Yes the values are set as numbers, I have attached an example worksheet if that helps.

Example worksheet.xlsx

[Pepe Le Mokko]

I don't see that you have tried the proposed solution in your sheet?