| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditionally formatting cells based on other cells
is it possible?
i have a cell that i want to format based on whether an adjacent cell is blank or not. ie Max_Allowable must be 'hidden' when Min_Needed = 0, Visible when Min_Needed < 0 the problem now is that if i want to conditionally format the Max_Allowable column, i can only compare values with "Max_Allowable", not the "Min_needed" i'd like to compare it with i know how to do the hidden - make the same colour as the background - part. I just need to know if I can base the format on another cell's contents... even using a macro if needed? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I conditionally format cells based on part of their text? | Excel Discussion (Misc queries) | |||
| Conditionally summing cells based on conditions in other rows | Excel Worksheet Functions | |||
| date updated conditionally based upon other cells | Excel Worksheet Functions | |||
| Conditionally formatting other cells? | Excel Worksheet Functions | |||
| Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
Threaded Mode
