Hi,

I have a somewhat complicated question regarding how to apply a function
under certain circumstances. Here's the situation:

I have a macro set up to color code the rows based on the information placed
in column A. However, I would like to eliminate the need to actually enter
anything into column A by placing a function (or Macro if possible) into the
rows of column A that will enter certain information when something is
entered into another cell.

For example:

Cell A6 is what we call a Status Column... all it tells us is what level of
appeal the claim is in. Cell A6 is also the cell that the macro corresponds
to in regards to our color coding. Cells W6, AE6, AK6, & AS6 are where we
get our information for the Status Column.

I need a function that will allow me to only have to enter information in
cells W6-AS6 that will automatically place the correct Status in the status
column (at which point the macro will kick in and update the coloring on the
spreadsheet).

Thanks :)

What are the rules for determining the status?

--
__________________________________
HTH

Bob

"akemeny" wrote in message
...
Hi,

I have a somewhat complicated question regarding how to apply a function
under certain circumstances. Here's the situation:

I have a macro set up to color code the rows based on the information
placed
in column A. However, I would like to eliminate the need to actually
enter
anything into column A by placing a function (or Macro if possible) into
the
rows of column A that will enter certain information when something is
entered into another cell.

For example:

Cell A6 is what we call a Status Column... all it tells us is what level
of
appeal the claim is in. Cell A6 is also the cell that the macro
corresponds
to in regards to our color coding. Cells W6, AE6, AK6, & AS6 are where we
get our information for the Status Column.

I need a function that will allow me to only have to enter information in
cells W6-AS6 that will automatically place the correct Status in the
status
column (at which point the macro will kick in and update the coloring on
the
spreadsheet).

Thanks :)

Um.. I'm not sure what rules you mean. But we determine the status based on
the those columns below. If we place reject in those columns the status will
change to one of the following:
RAC, FI, QIC, ALJ

If we place accept in those columns the status will change to: Closed

"Bob Phillips" wrote:

What are the rules for determining the status?

--
__________________________________
HTH

Bob

"akemeny" wrote in message
...
Hi,

I have a somewhat complicated question regarding how to apply a function
under certain circumstances. Here's the situation:

I have a macro set up to color code the rows based on the information
placed
in column A. However, I would like to eliminate the need to actually
enter
anything into column A by placing a function (or Macro if possible) into
the
rows of column A that will enter certain information when something is
entered into another cell.

For example:

Cell A6 is what we call a Status Column... all it tells us is what level
of
appeal the claim is in. Cell A6 is also the cell that the macro
corresponds
to in regards to our color coding. Cells W6, AE6, AK6, & AS6 are where we
get our information for the Status Column.

I need a function that will allow me to only have to enter information in
cells W6-AS6 that will automatically place the correct Status in the
status
column (at which point the macro will kick in and update the coloring on
the
spreadsheet).

Thanks :)

You are talking in very vague, general terms, whereas computers want
absolutes.

I am asking you to tell us what value in Cells W6, AE6, AK6, & AS6 will
determine what goes into the status column. Phrases like ... columns the
status will change to one of the following: RAC, FI, QIC, ALJ ... do not
clarify anything.

--
__________________________________
HTH

Bob

"akemeny" wrote in message
...
Um.. I'm not sure what rules you mean. But we determine the status based
on
the those columns below. If we place reject in those columns the status
will
change to one of the following:
RAC, FI, QIC, ALJ

If we place accept in those columns the status will change to: Closed

"Bob Phillips" wrote:

What are the rules for determining the status?

--
__________________________________
HTH

Bob

"akemeny" wrote in message
...
Hi,

I have a somewhat complicated question regarding how to apply a
function
under certain circumstances. Here's the situation:

I have a macro set up to color code the rows based on the information
placed
in column A. However, I would like to eliminate the need to actually
enter
anything into column A by placing a function (or Macro if possible)
into
the
rows of column A that will enter certain information when something is
entered into another cell.

For example:

Cell A6 is what we call a Status Column... all it tells us is what
level
of
appeal the claim is in. Cell A6 is also the cell that the macro
corresponds
to in regards to our color coding. Cells W6, AE6, AK6, & AS6 are where
we
get our information for the Status Column.

I need a function that will allow me to only have to enter information
in
cells W6-AS6 that will automatically place the correct Status in the
status
column (at which point the macro will kick in and update the coloring
on
the
spreadsheet).

Thanks :)

Ok... heres the detailed version then.

The column titles a

A6 = Claim Status
W6 = Accept / Reject
AE6 = Accept / Reject RAC Decision
AK6 = Accept / Reject FI Decision
AS6 = Accept / Reject QIC Decision

When:

W6 = Reject; A6 = RAC
AE6 = Reject; A6 = FI
AK6 = Reject; A6 = QIC
AS6 = Reject; A6 = ALJ

Currently the only one we can get to work is W6. The problem that we are
having is overriding the previous reject.

For example: We rejected the decision at the first level (W6) therefore the
claim status is RAC. We have sent out an Appeal to the next level (AE6), it
was upheld and we have rejected that decision... so now the Claim Status
should read FI (and so on).

What we don't want to have to do is manually change the Claim Status. We
would like it to automatically change to the correct level of Appeal based on
when we reject the previous decision.

"Bob Phillips" wrote:

You are talking in very vague, general terms, whereas computers want
absolutes.

I am asking you to tell us what value in Cells W6, AE6, AK6, & AS6 will
determine what goes into the status column. Phrases like ... columns the
status will change to one of the following: RAC, FI, QIC, ALJ ... do not
clarify anything.

--
__________________________________
HTH

Bob

"akemeny" wrote in message
...
Um.. I'm not sure what rules you mean. But we determine the status based
on
the those columns below. If we place reject in those columns the status
will
change to one of the following:
RAC, FI, QIC, ALJ

If we place accept in those columns the status will change to: Closed

"Bob Phillips" wrote:

What are the rules for determining the status?

--
__________________________________
HTH

Bob

"akemeny" wrote in message
...
Hi,

I have a somewhat complicated question regarding how to apply a
function
under certain circumstances. Here's the situation:

I have a macro set up to color code the rows based on the information
placed
in column A. However, I would like to eliminate the need to actually
enter
anything into column A by placing a function (or Macro if possible)
into
the
rows of column A that will enter certain information when something is
entered into another cell.

For example:

Cell A6 is what we call a Status Column... all it tells us is what
level
of
appeal the claim is in. Cell A6 is also the cell that the macro
corresponds
to in regards to our color coding. Cells W6, AE6, AK6, & AS6 are where
we
get our information for the Status Column.

I need a function that will allow me to only have to enter information
in
cells W6-AS6 that will automatically place the correct Status in the
status
column (at which point the macro will kick in and update the coloring
on
the
spreadsheet).

Thanks :)

Is this what you want?

=IF(AS6="Reject","ALJ",IF(AK6="Reject","QIC",IF(AE 6="Reject","FI",IF(W6="Reject","RAC",""))))

--
__________________________________
HTH

Bob

"akemeny" wrote in message
...
Ok... heres the detailed version then.

The column titles a

A6 = Claim Status
W6 = Accept / Reject
AE6 = Accept / Reject RAC Decision
AK6 = Accept / Reject FI Decision
AS6 = Accept / Reject QIC Decision

When:

W6 = Reject; A6 = RAC
AE6 = Reject; A6 = FI
AK6 = Reject; A6 = QIC
AS6 = Reject; A6 = ALJ

Currently the only one we can get to work is W6. The problem that we are
having is overriding the previous reject.

For example: We rejected the decision at the first level (W6) therefore
the
claim status is RAC. We have sent out an Appeal to the next level (AE6),
it
was upheld and we have rejected that decision... so now the Claim Status
should read FI (and so on).

What we don't want to have to do is manually change the Claim Status. We
would like it to automatically change to the correct level of Appeal based
on
when we reject the previous decision.

"Bob Phillips" wrote:

You are talking in very vague, general terms, whereas computers want
absolutes.

I am asking you to tell us what value in Cells W6, AE6, AK6, & AS6 will
determine what goes into the status column. Phrases like ... columns the
status will change to one of the following: RAC, FI, QIC, ALJ ... do not
clarify anything.

--
__________________________________
HTH

Bob

"akemeny" wrote in message
...
Um.. I'm not sure what rules you mean. But we determine the status
based
on
the those columns below. If we place reject in those columns the
status
will
change to one of the following:
RAC, FI, QIC, ALJ

If we place accept in those columns the status will change to: Closed

"Bob Phillips" wrote:

What are the rules for determining the status?

--
__________________________________
HTH

Bob

"akemeny" wrote in message
...
Hi,

I have a somewhat complicated question regarding how to apply a
function
under certain circumstances. Here's the situation:

I have a macro set up to color code the rows based on the
information
placed
in column A. However, I would like to eliminate the need to
actually
enter
anything into column A by placing a function (or Macro if possible)
into
the
rows of column A that will enter certain information when something
is
entered into another cell.

For example:

Cell A6 is what we call a Status Column... all it tells us is what
level
of
appeal the claim is in. Cell A6 is also the cell that the macro
corresponds
to in regards to our color coding. Cells W6, AE6, AK6, & AS6 are
where
we
get our information for the Status Column.

I need a function that will allow me to only have to enter
information
in
cells W6-AS6 that will automatically place the correct Status in the
status
column (at which point the macro will kick in and update the
coloring
on
the
spreadsheet).

Thanks :)

On Mon, 8 Sep 2008 12:26:03 -0700, akemeny
wrote:

Hi,

I have a somewhat complicated question regarding how to apply a function
under certain circumstances. Here's the situation:

I have a macro set up to color code the rows based on the information placed
in column A. However, I would like to eliminate the need to actually enter
anything into column A by placing a function (or Macro if possible) into the
rows of column A that will enter certain information when something is
entered into another cell.

For example:

Cell A6 is what we call a Status Column... all it tells us is what level of
appeal the claim is in. Cell A6 is also the cell that the macro corresponds
to in regards to our color coding. Cells W6, AE6, AK6, & AS6 are where we
get our information for the Status Column.

I need a function that will allow me to only have to enter information in
cells W6-AS6 that will automatically place the correct Status in the status
column (at which point the macro will kick in and update the coloring on the
spreadsheet).

Thanks :)

Just use conditional formatting based on the contents of column A.

If you have more conditions than allowed by your version of Excel (pre-2007: 3;
2007: many), you could use an event-triggered macro to do something similar.
--ron