Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm running Docs to Go 10.x on a Palm TX.
I have some files I need with me at all times. They integrate with each other using VLOOKUP, because they get updated pretty frequently. That requires way too much horsepower for the PDA, so I create "Mobile" files where, every time I update, I Copy + Paste Values so that the info's there without the LOOKUPS. However, I would like to keep the Conditional Formatting that's based on the LOOKUPS. Obviously, in Excel, the Conditional Formatting remains after the Paste Values (after all, the condition is still there). Trouble is, that doesn't translate to the To Go file. If I format a cell using the format menu, though, that DOES translate to the To Go file. So is there anything I can do that takes the CONDITIONAL formatting and applies it to that same cell as an UNconditional format? I hope this makes sense! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Making formula too complicated? | Excel Worksheet Functions | |||
need help making a formula | Excel Worksheet Functions | |||
Making too much of a formula | Excel Worksheet Functions | |||
Unconditional formatting | Excel Discussion (Misc queries) | |||
Making a formula continuous | Excel Discussion (Misc queries) |