mercredi 17 avril 2019

Using IFS in Conditional Formatting

I am completing a report based on margin growth. In my total margin column I want to highlight in green is we are equal or greater than then the sector avg and red if we are below.

For example - IF(H1=PAPER) and IF(O7>=0.3) then the cell should highlight in green.

There are seven product sectors that I need to include.

Aucun commentaire:

Enregistrer un commentaire