I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...
I am working on a spreadsheet that merges 20 columns into a single row. This row is conditionally formatted to display a data bar, of a proportional length based on a set of values from 0 to 275 that ...
Is it possible to have a conditional formatting cell “visually cycle” through all the formats that evaluated true?
Like the title says, "In Excel, when a cell has multiple conditional formatting rules that evaluate true, is it possible to have the cell "visually cycle" through all the formats that evaluated true? ...
An Excel column contains a text value representing the category of that row. Is there a way to format all the cells having a distinct value a unique color without manually creating a conditional ...
Is there a formula that I can use so that I can get a cell on Sheet 1 to have exactly the same formatting as a cell on Sheet 2?
I am using an excel spreadsheet to record skill competencies of staff. Sheet 1 will act as a "master" sheet reflecting the skill competencies of all staff (ie different employee in each column) and ...
Is it possible to prevent the contents of specific cells (or entire row or column) from printing in Excel? I need to maintain the cell size. I've been setting the text color to white before printing, ...
I recently set up a meeting with a colleague but must have ignored the fact that he had declined. So I showed up to the meeting alone. Is there any way to conditional format my Outlook 2007 calendar ...