software

I have an Excel spreadsheet that I run for our condo that lists the suite
numbers and the key numbers. The owners pay $12.00 for each key up to a
maximum of 4. Beyond that, they are charged $50.00. When an owner comes along
for another key, I would like the program to show quickly whether they owe
$12.00 or $50.00. They could come months later so there is no sequence as to
how many key they have except to labouriously check the list and count the
number of entries for their particular suite. I can do a sort by suite which
would show it up but I am wondering if there is a conditional formula that
can be used: i.e. IF(…THEN…) or something else.

Any help will be greatly appreciated.

Norm.Maybe use Conditional formatting on the column that you enter the Suite
number in......For cell A1, do Format gt; ConditionalFormatting, then

Set Condition 1 as Formula is.....=AND(A1gt;0,COUNTIF($A:$A,A1)lt;5) and set
background color to green

Set Condition 2 as Formula is....=AND(A1gt;0,COUNTIF($A:$A,A1)lt;4) and set
background color to red........

Then click on A1 and then click on the FormatPainterBrush in the toolbar and
then paint it over the rest of column A as far down as you have data, or
expect to have data...........
Then, whenever you enter a Suite number in column A, if it has been entered
4 or less times, the cell will turn green, if 5 or more times, the cell will
turn red........

hth
Vaya con Dios,
Chuck, CABGx3
quot;Norm75quot; wrote:

gt; I have an Excel spreadsheet that I run for our condo that lists the suite
gt; numbers and the key numbers. The owners pay $12.00 for each key up to a
gt; maximum of 4. Beyond that, they are charged $50.00. When an owner comes along
gt; for another key, I would like the program to show quickly whether they owe
gt; $12.00 or $50.00. They could come months later so there is no sequence as to
gt; how many key they have except to labouriously check the list and count the
gt; number of entries for their particular suite. I can do a sort by suite which
gt; would show it up but I am wondering if there is a conditional formula that
gt; can be used: i.e. IF(…THEN…) or something else.
gt;
gt; Any help will be greatly appreciated.
gt;
gt; Norm.
gt;

Many thanks - I am sure this will do the trick. Norm.

quot;CLRquot; wrote:

gt; Maybe use Conditional formatting on the column that you enter the Suite
gt; number in......For cell A1, do Format gt; ConditionalFormatting, then
gt;
gt; Set Condition 1 as Formula is.....=AND(A1gt;0,COUNTIF($A:$A,A1)lt;5) and set
gt; background color to green
gt;
gt; Set Condition 2 as Formula is....=AND(A1gt;0,COUNTIF($A:$A,A1)lt;4) and set
gt; background color to red........
gt;
gt; Then click on A1 and then click on the FormatPainterBrush in the toolbar and
gt; then paint it over the rest of column A as far down as you have data, or
gt; expect to have data...........
gt; Then, whenever you enter a Suite number in column A, if it has been entered
gt; 4 or less times, the cell will turn green, if 5 or more times, the cell will
gt; turn red........
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Norm75quot; wrote:
gt;
gt; gt; I have an Excel spreadsheet that I run for our condo that lists the suite
gt; gt; numbers and the key numbers. The owners pay $12.00 for each key up to a
gt; gt; maximum of 4. Beyond that, they are charged $50.00. When an owner comes along
gt; gt; for another key, I would like the program to show quickly whether they owe
gt; gt; $12.00 or $50.00. They could come months later so there is no sequence as to
gt; gt; how many key they have except to labouriously check the list and count the
gt; gt; number of entries for their particular suite. I can do a sort by suite which
gt; gt; would show it up but I am wondering if there is a conditional formula that
gt; gt; can be used: i.e. IF(…THEN…) or something else.
gt; gt;
gt; gt; Any help will be greatly appreciated.
gt; gt;
gt; gt; Norm.
gt; gt;