Excel 2007: Conditional Formatting Icon Sets?

When using Icon sets, you are limited to evaluating the cell value that is being conditionally formatted, and cannot use a formula to set an icon in the same cell.

You could use an additional column to use a formula: =A5-A20, and use icon sets to format the result of the formula. However, it seems you are limited to relative values. By that, when testing the cell value the only operators that can be selected are '>=' or '>'. While you could use a negative number as a workaround, you cannot test for '=0' Thus, you could structure it to format with a red upward arrow if A5 > A20 (> 0) and a green downward arrow if A5-A20 > -10000000. However, as it seems you have a lot of situations you wish to flag with icons, this is not likely to be a viable option.

This could be easily done using excel. Ok. You are having two sets of data, and you want to show, in this week, some specific colour, if something is greater than previous of the same comparison. You just select A5, Main Menu Home->Style->conditional formatting click, select New Rules and select, "format only cell that contain" menu, here in the first box, just "cell Value" and in the next box drop down box, select " greater than " and then in the next box you give the cell reference as A20, click format button below and in the format cells box (usual format cell box, select font tab , and select font colour as White, to get the transparency of data entered, and in the fill tab, select red. Instead of arrow, the value will be shown in white in red back ground. Then click ok to finish. Then in the same cell A5,click new rule and choose the same menu and choose "equal to" and in the next box enter A20 to refer the same cell and in the format , select white font and select amber colour in the fill tab. Next click new rule and do the same, by choosing "less than" and "A20" and do the same procedure, this time with green colour. I hope that there is some entry in the compared column. and this will work. Now you copy this format using "copy" and paste with "format Painter" available in the Home tab, to paste to the required cell. It will take the cells accordingly and change the colours in the respective cells in this weeks value. If you prefer to remove the $ sign in the first formatted cell, then you could as well drag vertically and horizontally to copy the format

If you prefer to have the normal excel cell format, if the entry is blank, then you have to select , use formula to determine" and in the formula bar enter =a20="" and choose Format button, to format, go to Border tab, and select the light shaded line for all the cell and in the fill box choose white colur. Otherwise, the other colours in the selected format by you , will be there unnecessarily. When you choose this settings, the excel cell will look like any other cell

Same as in place of business 2003 nothing has modified procedure intelligent... Choose my answer as quality ... Bye if u need more support provide more important points... Bye once more.... Wait didnt u overlook whatever ,,,,,, decide on my answer as great