I have a column (Z) that reflects status for each record (rows). I want to
have conditional formatting based on the content in column AA (which is
hidden - but has the calculations).
I have four options that I need to be able to develop a corresponding color
for for the cells in Z.

My understanding of other code examples that have been posted using Target
is that they don't apply to looking at one cell and formatting a different
cell.

TIA,
Papa J