Conditional Formatting to highlight the previous cell if the statement is true

[ExcelNewbie2020]

Sirs/Ma'ams,

My formula is working good with conditional formatting if the statement is true. It highlight the cell as normal.

Now, i would like to highlight the previous cells (instead of current) if the statement is true. See below

This is the formula that I use..
=IF(COUNTIFS(Sheet1!$B$9:$B$500,$B6,Sheet1!$K$9:$K$500,G$5,Sheet1!$L$9:$L$500,"Active"),TRUE,"")

I hope I explain it well..

Many Thanks,

 

[ExcelNewbie2020]

Ok, thanks for that, change the formula to

=COUNTIFS($B$1:$B$11,$F2,$C$1:$C$11,H$1,$D$1:$D$11,"Active")

And It works like a charm... thank you very much...

 

[Fluff]

You're welcome & thanks for the feedback.