Coloring cells

[SamanthaKorenel]

Hello, so on previuos post i posted how to find largest value code. So know i have my price list and i want to apply colors on them, So in example if product value i less than 5 you give it red if less than 2 you give it yellow. Simple as that.

 

[JamesLoft]

Hello again, so you can do it by going Conditional formmating and create new rule:
Select a rule type, "Format cells that only contain", If you want to color cells who is less than 5 just, just select "less than" and write 5 in blank cell, if you want more than 8, press "greater than" and insert 8.

 

[SamanthaKorenel]

Yes it worked, but what if i want to color cells, who has value like 5,6,7,8?

 

[JamesLoft]

Just create a new rule, by making it "between" and entering in blank cells 5 and 8, it will color all values between 5 and 8, including themselves.

 

[MARK858]

If you arrange the rules in the correct order you can do it all with the cell value less than.

Excel Workbook
	A
1	2
Sheet6

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Cell Value less than 2	Abc
A1	2. / Cell Value less than 5	Abc
A1	3. / Cell Value less than 9	Abc

 

[SamanthaKorenel]

Thank you!