I TRIED USING "=AND(D1>0,E1>0,F1>0)" DIDN'T WORK AND I WANT IT TO APPLY TO A RANGE OF "C11:H40", IF AL THREE STIPULATIONS ARE MET IN THAT ROW I WANT A HIGHLIGHT AND BOLD TEXT TO APPEAR IN THAT WHOLE ROW
=AND(D1>0,E1>0,F1>0)
Aucun commentaire:
Enregistrer un commentaire