Thats the dumbest thing I seen. Thats if he's using 07 an I dont know that yet, an you cant tell whats in cell D1 any way. If he's using 07 the number will show up that its lower the 10%What's your point, squall_01? If you want to know the forumla in D1, ask. It's =C1/A1.
If he's using 07 the number will show up that its lower the 10%What was the point of this remark? I simply posted the case where the change was greater than 10%. Do I need to post another screen print showing a case where the change was less than or equal to 10% and displayed in yellow to convince you that conditional formatting works? Don't be ridiculous. In my last post, I said, "Using conditional formatting in this case simply requires using two conditions, one for change <= 10% and one for change greater than 10%."
It's just as easy in Excel 2003 as in Excel 2007.I figured so. ::) Thanks for confirming that. :)
It's just as easy in Excel 2003 as in Excel 2007.I figured so. ::) Thanks for confirming that. :)
It's just as easy in Excel 2003 as in Excel 2007.I figured so. ::) Thanks for confirming that. :)
Although, technically it may be a little easier in 2007. Especially if the Home tab is already selected. In that case you would only have to click once to bring up the dialog. :P
I should have been more specific. I meant periods of the year, so the first column covers Jan., 2nd column, Feb. I need Feb column to show either yellow for a 10% or below difference and red for above 10% difference. I'm not sure if I need to write and actual formula for this or if I can select an option from the dropdown list in the conditional formatting box.Regardless of whether the cells contain data for days, weeks, or months, the principle is the same. You need one or two columns to calculate the change. In the example-image I posted earlier, I used two columns; that can be consolidated into one column. So, column C could be used to calculate the percentage change between whatever is represented in A1 and B1. Conditional formatting would be applied to Column B, then, to accomplish your objective. If you don't want to see the column(s) used to calculate the change, then just hide it/them.