Hey Pals!
I have a column which has price ranging from 100 to 5000...
What i want to do is that, if the price range is <1000, put red colour, >=1000 and < 2000 yellow... and for >3000 Green colour..
Please help someone .......
Hey Pals!
I have a column which has price ranging from 100 to 5000...
What i want to do is that, if the price range is <1000, put red colour, >=1000 and < 2000 yellow... and for >3000 Green colour..
Please help someone .......
Refer the attached sheet.
The last criteria should be >=2000.
If it is above 3000, the cells which has a range 2000-2999 will not have any impact.
Regards
Shareez
i see you have excel 2010+
so traffic lights is the way to go
step by step instructions can be found here
https://stevechasedocs.wordpress.com...matting-dates/
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
meus, Good evening.
Select cells you want to format.
Conditional Format Menu --> Using Formula
Suppose colunm D is your colunm.
Rule 1
=D1>=2000
Fill format colour GREEN
Rule 2
=AND(D1>=1000;D1<2000)
Fill format colour YELLOW
Rule 3
=D1<1000
Fill format colour RED
OK
Is that what you're looking for?
I hope it helps.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
Good afternoon
Try this form below it is a small sample
regards
regards
Peter
Thank you all it works great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks