This would be me giving to you. Though it’s only a small piece of probably not-so-useful information, it’s sharing nonetheless. So Happy New Year, okay?
I love learning new things, and I especially like learning things that work for me and make my life easier. Such a thing happened this morning, and it was a beautiful moment. (Okay, maybe that’s just a bit over the top, but it was still fun!)
While I don’t live in Excel and am much more a graphics/creative type gal, I do have great appreciation for a well-designed spreadsheet or two. This morning, I was on a mission to get my spreadsheet working for me – you know, alerting me when things are different.
If you’re at all into “IF” statements in Excel, you know how much they rock. I wanted an “IF” statement that changed the font color when the value fell below zero … but that wasn’t meant to be through the use of an “IF” statement. A quick google search led me to the “Conditional Formatting …” option under the “Format” menu. Awesome! Here, you can set up several different conditions and resulting changes in the cell color, font formatting, and cell border. Awesome!
I ended up using two conditions – one that changed the font to red if the cell value dipped below zero, and a second that turned the cell orange with a white font if a value was missing.
Try it out – okay, not just for fun (Because it’s really not that fun.), but if you have the need! Get your work working for you!