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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting based on values of another cell
Conditional formatting does not normally let you set the criteria on another
worksheet or workbook. However, you can get around this in your case by giving Data!O3 a name (Insert/ Define/ Name). Let's say you name the cell "O_3". Then on your Inventory sheet, Conditional Format, select Formula is = O_3 < 11 apply red = O_3 < 21 apply blue = O_3 < 31 apply gray Mike F wrote in message ups.com... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting based on values of another cell
Nice one Mike
Cheers Tony |
Reply |
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 |