Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating cell based on multiple inputs from another sheet
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Significant number rounding based on key cell | Excel Worksheet Functions | |||
Want cell ref. to change after sort in other sheet | Excel Discussion (Misc queries) | |||
Conditional Formating for a cell based on another cell's value | Excel Discussion (Misc queries) | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |