In my attendance sheet I want to the percentage in the T column to show up black if they have attended 75-100%, Orange 50-75% and red if they are below 50% attendance. Does anybody know the formula to get that done.
In my attendance sheet I want to the percentage in the T column to show up black if they have attended 75-100%, Orange 50-75% and red if they are below 50% attendance. Does anybody know the formula to get that done.
You need conditional formatting for that..
Check attached..
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
If 75 and 50 have to be included for brown and red respectively then use this--
Deleted post
Last edited by BlindAlley; 07-22-2015 at 10:20 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks