I had a Conditional Format in Place, but it somehow stopped working once I filled in an
IF Argument into my cell.
A1 Contains a Number I put in manually
A2 Contains another Number I put in manually
A3 Contains a Number which changes (with
IF Arguments) depending on which number is input into
A3 Is supposed to change it’s color depending on the Number it contains.
My Argument for
=IF(A1=1, "3", IF(A1=2, "6", IF(A1=3, "3", if(A1=4, "6","N/A"))))
I had my Conditional Format on Cell
"Custom Formula is" with the Formula being
=A2=A3 -> Green
and a second one as
=A2<A3 -> Red