For example, you can apply conditional formatting in such a way that all negative values in a range have a light-yellow background color. About Conditional FormattingĬonditional formatting enables you to apply cell formatting selectively and automatically, based on the contents of the cells. In some cases, conditional formatting may be a viable alternative to creating a chart. You can apply conditional formatting to a cell so that the cell looks different, depending on its contents.Ĭonditional formatting is a useful tool for visualizing numeric data. This chapter explores the topic of conditional formatting, one of Excel’s most versatile features.
How to use the graphical conditional formats.An overview of Excel’s conditional formatting feature.TL DR: I just want colors in these two columns so a quick glance will give me an idea of daily performance with good=green, acceptable=yellow, and bad=red. Please help point me in the right direction if you can, I thank you so much in advance, this tool will be amazing for my team! Got close a few times, then screwed it up. I don't expect anyone to simply write the formulas (although id be ecstatic) but I tried everything I could find online and i could not make it work. I apologize for the formatting, I'm on mobile and this wasn't easy to type up. I did my best to explain what I'm looking to accomplish, I hope I made sense. At this point I'd pay someone to do it, and I'm sure there's an excel genius here that could do it in 3 minutes and make me feel like an idiot. How the hell do I write these formulas? I played around with it for hours and couldn't figure it out. If there are 0 locks and 0 submissions, I want them to know they'd better pick it up (hence the red) If they only get a "lock" and 0 "submissions", I want the 0 to be in a yellow cell, showing that it is acceptable to have 0 submissions as long as they have a lock (hence the 0 being in a yellow cell) and vice versa.
All other data in the rest of the spreadsheet is independent of these two columns.Īs you can see, I expect there to be at least one "lock" and one "submission" each day (hence both green=good). Obviously, these two columns are "related", but only to each other. NOTE : each row is a workday that tracks daily production. If there is NO data entered in the a cell, there is no fill. If both = 1 or greater, Both fills are green If Locked = 0 and Submitted = 1 or greater, Locked Fill is Yellow and Submitted fill is Green
If Locked = 1 or greater and Submitted = 0 Locked Fill is Green and Submitted Fill is Yellow Here are the conditions I need for the sheet and a screen shot of what I am shooting for (I just filled the cells for the example) : The part of this sheet I'm having trouble with is only 2 columns: "locks" and "submissions". I'm not very formula savvy so I was hoping some of you could help me out.
The formatting I am looking to do seems rather simple, but I cannot get it to work. I am in Finance and I am trying to design a sheet that not only has useful info, but has conditional formatting so that I'll have a good idea of our daily performance without diving too far into the data (think heat map but simpler - no gradient, just 3 colors for good, bad and ugly).
I use excel 2016, and I am looking to do some conditional formatting for a spreadsheet I will use daily to track the metrics I use for my sales team. Pls bear with me and if I break any rules, I will fix and repost. Mods, I hope I'm not breaking any rules here, I looked at the sidebar so I will try to be as specific as possible. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data.
NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.