Is there a way to do basically a reverse of the conditional formatting -
where the certain cells have a pattern assigned to them already, and is there
a way to in another column have that change to either a numeric value or even
a true false.

Like if cell A1 has a red background have B1 come up with sometype of a
number that would be different that if the background was blank.