The question was "... set the background colour of a cell ... if the value
of any cell
in a range ...". For me it means to set the color of ONE cell depending on
the values of several cells. Yor solution sets the color of a range of cells
depending on the cells own values. The OP shared this interpretation!
Regards,
Stefi
„Ms-Exl-Learner†ezt Ãrta: