Conditional Format with conditions

Question

Good Morning,

I would like to do a conditional format based on the entered value D26:N32) and parameters set by the type of unit used to collect the data.

A value gets entered into the table D26:N32.

If the value is over the threshold indicated in rows 23 &,24, I want it to turn red

I tried the following formula for D26-D32 with success =D26>IFS($C26=C$23,D$23,$C26=C$24,D$24)

But when I try to apply the format to the other columns, It doesn't work

The threshold is pulled from 2 different tabs in the workbook

Answer 1

For your new screenshot:

=SUM(--(D8:R14>IFS($C8:$C14=$C$4,D$4:R$4,$C8:$C14=$C$5,D$5:R$5,TRUE,1000000)))

Answer 2

Use

=D26>IFS($C26=**$C$23,D$23,$C26=$**C$24,D$24)

Answer 3

Hi Ashish,

The logic on the colored cells was my 1st question that Hans gave me a formula for. =D26>IFS($C26=**$C$23,D$23,$C26=$**C$24,D$24)

Answer 4

Hi,

There is no built-in function to count coloured cells. Not unless you can share the logic based on which those cells were coloured.

Answer 5

That worked great! Thank you!

Would you also be able to provide me with a formula to calculate the number of fails per date. So counting all the red cells. It should return the value in column U.

In addition for column T, I want to know how many passed during the initial test. I.e. Row 8 failed 1 time, so out of the 5 sites in row 6, 4 sites passed on the 1st go. row 10, even though there are 2 failures, out of the 5 sites, 4 passed on the 1st go.

In row 11, out of the 5 sites in row 6, only 3 passed on the 1st go.