Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on values from other sheet
I have two worksheets: Inventory and Status
Status has two columns A B Fridge In Stock Stove Out of Stock Oven Low Stock What I would like to do is when sheet2 is modified, "Fridge" for example is changed from In Stock to Low Stock it searches Sheet1 for the word "Fridge" and changes the background color to Yellow. Because "Fridge" can be in any column or row it can't be tied to a specific cell. Is there a way to accomplish this through conditional formatting? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting based on top values | Excel Worksheet Functions | |||
Conditional Formatting in Pivot Based on other values in pivot. XL | Excel Discussion (Misc queries) | |||
Conditional values based on formatting? | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) |