Formating

[ismail]

Hi,
In a Column 'A' sales Commission is calculated and resulta
is as 250, 200, 300, 330.
I wanted to format a cell with a Blinking colours where
value is 100 to 250, 250 to 300, 300 to 350 and 350 &
above.
please help to format my sheet ... thanks

 

[Casey]

Ismail,
Getting your cells to "blink" is not in the standard Excel formats
What you want would require some extensive programming, certainly, ou
of my capabilities.
However, there are some great things you can do with Excel'
CONDITIONAL FORMATTING.
Let's say in column A you have numbers that are the result of formula
in those cells or just numbers you have entered manually. Select thos
cells and go to FORMAT>CONDITIONAL FORMATTING.
This brings up a dialog that allows you to set a condition and the
pick a format that alerts you to that condition.
For example Condition 1 could be "Cell Value is" / "Between" / 0 /200
Then click the FORMAT button and a dialog will come up that allows yo
to set a font type a cell color or pattern, any of Excel's standar
formatting options. With that done you can return to the CONDITIO
FORMATTING dialog and click the ADD>> button and create anothe
condition and then set a custom format for that condition.
The only limit is that for any group or range of cells you are limite
to three conditions.
Hope this helps
Case