how about you create another column and concatenate A and C, then do this:
When you concatenate serial and pass/notpassed you have a unique value for serial A-pass and serial A-"not passed" and then you can countif them
Actually you have to translate your liking to formula:
"I wanna highlight any cell in column red, yellow and green which is empty AND has an id on the id column"
So it's or (red,yellow,green) and (id) *logic
You can try building the formula in a cell and see if it returns true when all conditions are met and false when they aren't
Say the columns are A,B,C ...
In your formula you have to omit the >1.
Your Conditional Formatting formula should be:
(The answer provided is in relation to your info. There is vital info missing from your question. I am not sure what exactly you try to achieve. Play around with the $ sign as well as the range and see your different results. Next time ...
One workaround is to use Google Apps Script instead of the built-in conditional formatting options but it doesn't performs so efficiently.
Question with the larger score so far
How can I set conditional formatting on a particular cell that depends on another cell's value?
I think the relative and absolute reference would help you with this.
There are 3 types of them:
$A1 Allows the row reference to change, but not the column reference.
A$1 Allows the column reference to change, but not the row reference.
$A$1 Allows neither the column nor the row reference to change.
In your case, I think you only want the column ...
The formula you need is the following:
Please pay attention to the $ sign in front of H3.
Using the $ (dollar) sign we "lock" the column and the formatting is being applied on the whole row.
You apply the formula on the range I3:AA.