Forum Discussion
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
- RichWebsterCopper Contributor
hi there, best to use conditional formatting > New Rule > "format only Cell that conttain"
now fill out your criteria
Rich
- NikolinoDEGold Contributor
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)