Forum Discussion

Souleimene Kayoueche's avatar
Souleimene Kayoueche
Copper Contributor
Oct 01, 2017
Solved

Conditional Formatting - using multiple formulas

Hi,   I'm struggling on how to use the conditional formatting function.    I would like to achieve the following: change the colour of cells in column "I" when two things are true:   1. When th...
Formulas & Functions
Tutorial
  • JKPieterse's avatar
    JKPieterse
    Oct 02, 2017
    Use the formula option to define the rule and use this formula:

    =AND(F10="rowing",I11>25)
JKPieterse's avatar
JKPieterse
Silver Contributor
Oct 02, 2017
Use the formula option to define the rule and use this formula:

=AND(F10="rowing",I11>25)

Resources