Does anyone know of a way to check for a value in two different cells, and if
a certain combination of values exists, change the format of another cell?

Any help would be much appreciated.

Thank You.