How to custom a cellformat to give color to % values as i need to?
Heres my question:
I have a list of porcentage results, what i want to achive is that any value under 15% would color it self in red, and the ones over the 15% to stay in black.
Same happens to me in another list where i have accounting results, i would need also that anything over $30,000,000.00 would color itself in red, anything under that to stay in black,
It would be amazing to get help on this
Hi and welcome to the forum
Take a look at Conditional Formatting...home tab/styles
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
YurekJ, welcome to the forum.
Select the range your results are in --> Conditional Formatting --> Highlight Cells rule --> Less Than, select 15, format as required.
Hope this helps.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Sorry because im really new, first day. Where should i type "--> Conditional Formatting --> Highlight Cells rule --> Less Than, select 15, format as required.", so i can get to the answer that would help me?
no, look on the menu at the top. click on the HOME tab, then look for the STYLES tab, and click on the CONDITIONAL FORMATTING icon
You don't type most of that. If you look towards the top of your Excel window, there is a row of options and tabs across the top of it - this is what's known as the Ribbon. On the Home tab of the ribbon, just over halfway across (from the left) there's a button called Conditional Formatting. If you click on that, you'll see the other options (highlight cells) etc, that I referred to above.
Got it, thank you all, now how do i mark, that my question was solved?
Glad to help, and thanks for the rep. Scroll to the top of the page, click on "Thread tools", and mark solved.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks