Rookie user; need help please

%3CLINGO-SUB%20id%3D%22lingo-sub-1547332%22%20slang%3D%22en-US%22%3ERookie%20user%3B%20need%20help%20please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547332%22%20slang%3D%22en-US%22%3E%3CP%3ENew%20user%2C%20apologies%20for%20asking%20for%20help%20for%20IF%20statement%20with%20several%20conditions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20cell%20value%20is%26lt%3B7%2C%20then%20return%20%22purple%20fill%22%20of%20the%20cell%2C%20and%3C%2FP%3E%3CP%3Eif%20cell%20value%20is%207-8%3A59%2C%20then%20return%20%22green%20fill%22%20of%20the%20cell%2C%20and%3C%2FP%3E%3CP%3Eif%20cell%20value%20is%209-12%3A59%2C%20then%20return%20%22yellow%20fill%22%20of%20the%20cell%20and%3C%2FP%3E%3CP%3Eif%20cell%20value%20is%2013-15%3A59%2C%20then%20return%20%22orange%20fill%22%20of%20the%20cell%20and%3C%2FP%3E%3CP%3Eif%20cell%20value%20is%20%26gt%3B16%2C%20then%20return%20%22red%20fill%20of%20the%20cell%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1547332%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGeneral%20Comment%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERequests%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETutorial%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1547375%22%20slang%3D%22de-DE%22%3ERe%3A%20Rookie%20user%3B%20need%20help%20please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547375%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F740755%22%20target%3D%22_blank%22%3E%40DianaH1964%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ea%20quick%20example%20with%20conditional%20formatting%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20answer%20suits%20you%2C%20please%20click%20as%20correct%2C%20so%20that%20others%20know%20which%20is%20the%20right%20answer%3C%2FP%3E%3CP%3E...%20a%20thumbs%20up%20would%20also%20help%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1547341%22%20slang%3D%22en-US%22%3ERe%3A%20Rookie%20user%3B%20need%20help%20please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547341%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F740755%22%20target%3D%22_blank%22%3E%40DianaH1964%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehi%20there%2C%20best%20to%20use%20conditional%20formatting%20%26gt%3B%20New%20Rule%20%26gt%3B%20%22format%20only%20Cell%20that%20conttain%22%26nbsp%3B%3C%2FP%3E%3CP%3Enow%20fill%20out%20your%20criteria%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22RichWebster_0-1595842498494.png%22%20style%3D%22width%3A%20557px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F208090i69B4C73F4648E3D3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22RichWebster_0-1595842498494.png%22%20alt%3D%22RichWebster_0-1595842498494.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERich%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 Replies

@DianaH1964 

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

now fill out your criteria

 

RichWebster_0-1595842498494.png

 

 

Rich

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