There are several other columns in the spreadsheet, but I want to keep all
the information in Column A and only turn those balances red if col b equals
AUD. I need to delete Column B and when I do that the items in Col A that
were previously turned red the color disappears when I delete Column B.

Col A Column B
InvoiceBalance. Aud
$1,280.00 instal
$3,251.55 instal
$200,000.00 Aud



"Donna" wrote:

How can I format Column A to change colors if the corresponding line in
Column B equals "Aud". I then need to delete the reference Column B and have
the colors in Column A remain after I delete column B. Thanks Donna