I have an expense tracker where I have positives in blue and negatives in red but I want to have those values be in gold if an adjacent value is one of 2 other values.
Based upon another thread I came up with these conditions:
=AND($B$2>0,$D$2<>"Condition 1",$D$2<>"Condition 2")
=AND($B$2<0,$D$2<>"Condition 1",$D$2<>"Condition 2")
=OR($D$2="Condition 1",$D$2="Condition 2")
It works perfectly when only applied to the first cell. When applied to the entire column it still looks at d2 because of the absolutes.
How do I apply that to an entire column with hundreds of existing rows without messing them up? No matter what I try it still looks at the first row.
