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 :)