Formating cell based on multiple inputs from another sheet

D

Don

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I copy data produced by a formula, not the formula? 2
Copy entire row from another sheet onto first sheet if a unique text matches 1
List box change values based on selection 0
Conditional formating based on blank cell 3
Loop to hide sheet based on cell 1
Formula to fill one cell from another 0
Paste Values Based on Conditional Value 0
conditional format of entire row based on a single cell in row 7

Top