I remember doing the same. The one thing I could never figure out was how to change the background colour other cells that do not contain the value (e.g. changing the background colour of an entire row based on one value in that row). If you happen to figure it out, I’d appreciate it if you’d let me know.
The only way I was able to make the whole row format was to merge all the cells, but that only permits one result in the merged cell.
Don’t know if this helps or not, but I couldn’t work any other way as the conditional formatting does not allow you to select the particular cells you want formatted, it only allows you to use the cell that has been selected to do the formatting on.