| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set a conditional format on value in another worksheet?
Wanda
If you name the cell on the other worksheet you're good to go. On sheet2 select the cell with the value and InsertNameDefine. Give it a name like MyName On sheet1 your A1 CF formula will be =A1<MyName Gord Dibben MS Excel MVP On Thu, 18 Jan 2007 12:07:02 -0800, Wanda wrote: I need to set a conditional format based on a value that is in a worksheet other than the one in which I'm setting the conditional format. Excel tells me this cannot be done. Is there a workaround? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format (not color format) | Excel Discussion (Misc queries) | |||
| Conditional format won't copy | Excel Discussion (Misc queries) | |||
| Conditional Format Not Working | Excel Discussion (Misc queries) | |||
| How do I do a conditional format for numbers | Excel Worksheet Functions | |||
| Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
