Hello, I going to export some data into Excel from Access. I'm fine with
getting the data into one of the worksheets but then I wanted to further
format the data to display to end users on a new worksheet.

For example; let's say my raw data (In Sheet1) looks something like this
Column1/Column2/Column3
ProductA/BackOrder
ProductB/Available/OnDisplay
ProductC/Available/StockRoom
ProductD/PreOrder

I'm good with getting the product description into the second worksheet with
referencing the column but then want to change the color of the cell(where
the prooduct description is placed) based on (Backorder = red, Available =
green, PreOrder = blue). Then I want to further format the product cell to
have a border go down diagonal when it's OnDisplay.

Is this possible?

Thanks

Don