sl no name tct count sgt count
1 hhh 23 2380
2 iii 28 3580
3 jjj 26 4300
4 kkk 20 5800
sir my querry is>> via conditional formatting how can i mark row "red color" for the names who fall between 2000-3000 sgts,"yellow color" for names falling between 3000-4000 blue color if some one falls between 4000-5000 and green for persons falling between 5000-6000 sg countsmay be in future more names will be added and they should choose automatically their color as per their sg t counts.how is it possible can some body help me out>>please note that all are in seperate columns>>
Bookmarks