| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting based on values of another cell
Is it possible to apply conditional formatting on cells based on the
values of other cells. For example, if value of O3 on sheet 'Data' is between 1-10 then make the background of cell L2 on sheet 'Inventory' red. Likewise, if same cells 11-20 apply blue and if same cells 21-30 apply grey? This would be applied to 30 columns and approx 450 rows? Thanks Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional function row formatting based on columns values being | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on values from other sheet | Excel Worksheet Functions | |||
| Conditional Formatting based on top values | Excel Worksheet Functions | |||
| Conditional values based on formatting? | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Threaded Mode
