Conditional formatting of a cell with the matching value if another cell is not blank

I currently have a block of cells with dynamic values and then I have another single cell with a static value. I created a rule that formats only cells in the block of cells of those that contain cell value of the single cell with the static value. Now I want to add another single cell, a value of which will trigger the aforementioned formatting rule. Basically, if this new cell is not blank, then execute the formatting of cells in the block that match the value of the cell that has the static value. In the attached example, the trigger cell is O5 and it should turn formatting on or off with any value. The blueish fill of the cell D5 is a result of the conditional formatting because it matches the value of K5.

You have to apply two rules here as per following order to meet your criteria for this CF;


Ist Order Rule = Formula Rule (applied to cell range C5:G5);

=ISBLANK($O$5)

Format= No Fill

Check the BOX "STOP IF True"



2nd Order Rule = Format only Cells that Contain (applied to cell range C5:G5);

Cell Value = equals to =$K$5

Format = Blue



Remember: Apply both Rules in the order mentioned above, otherwise it will not work.

Thank you very much, seekerarcane! Simple solution and makes sense. Although the solution works, but unfortunately it will not work for me: I probably should have mentioned that my actual project consists of multiple and much bigger blocks of cells and also multiple cells that can apply formatting to the same block of cells. Therefore, the solution should only target that specific formatting rule and not the whole block of cells.

Any other idea? Anyone?

Aardigspook, that was exactly what I was looking for! Thank you very much!