Rookie user; need help please

[DianaH1964]

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

[#2]

@DianaH1964 

hi there, best to use conditional formatting > New Rule > "format only Cell that conttain" 

now fill out your criteria

Rich

[#3]

@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)