G
Guest
Is there any way to change the color of the row based on the value of PM in
the cell and then check the rest of the spreadsheet for the PM value and
change the color of the rest of the row? See example below.
Project Amount PM Color desired
123 125000 DG red
234 26715 CG blue
345 1243 EG green
456 258000 CG blue
567 12589 CG blue
678 77500 DG red
789 65875 EG green
the cell and then check the rest of the spreadsheet for the PM value and
change the color of the rest of the row? See example below.
Project Amount PM Color desired
123 125000 DG red
234 26715 CG blue
345 1243 EG green
456 258000 CG blue
567 12589 CG blue
678 77500 DG red
789 65875 EG green