Hello all!,
Is there a way for a formula if in a row if a cell has number for example 5 it would make that cell red, Then if there was a number that was 6 it would be green.
I have this long list and i have to go down each cell and if it is one number it has to be that color and if it is another number it would be a different color.
Hopefully i did not lose you.
Yes you can do conditional formatting for the same.
Checkout below link
http://www.excel-easy.com/data-analy...ormatting.html
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Ahh got it thank you!
Not sure if you will know this but thought i would ask. Is their a way for a whole row that shows for example 5,5K is thei a formula to have it changed to 5,500 instead of going through each one?
Yes select the whole column or row where you need to implement then press control+H ->>> this is find and replace option,,, put the value for find and replace with another value what you want to see instead of current value.
Hope this would help you.
Ah very nice that worked awesome thank you so much!!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Please add reputation by clicking star * icon on left corner on the thread post which helps you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks