Forum Discussion

DianaH1964's avatar
DianaH1964
Copper Contributor
Jul 27, 2020

Rookie user; need help please

New user, apologies for asking for help for IF statement with several conditions.

 

If cell value is<7, then return "purple fill" of the cell, and

if cell value is 7-8:59, then return "green fill" of the cell, and

if cell value is 9-12:59, then return "yellow fill" of the cell and

if cell value is 13-15:59, then return "orange fill" of the cell and

if cell value is >16, then return "red fill of the cell

 

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    DianaH1964 

    a quick example with conditional formatting

     

    If the answer suits you, please click as correct, so that others also know which is the right answer

    ... a thumbs up would also help 🙂

     

    Nikolino

    I know I don't know anything (Socrates)

Resources