About a year ago I had to color certain cells based on certain numbers or combinations of numbers.
Someone answered my inquiry and provided me with a formula and how to set it up.
An example of the formula I used was:
=SUM(IF(A7=PNAMES,ERROR*ASSIGNED))
However, I cannot remember how to change the formula. Can someone walk me through how I can do this?
Thank You
Someone answered my inquiry and provided me with a formula and how to set it up.
An example of the formula I used was:
=SUM(IF(A7=PNAMES,ERROR*ASSIGNED))
However, I cannot remember how to change the formula. Can someone walk me through how I can do this?
Thank You