| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight field that are not derived from a formula
Hi Folks,
I've got a question/problem I can not solve on my own. I want to format a cell this way that the background becomes e.g. red if the content is not defined via a reference. e.g. Cell Content Highlight A1 =B3 no A2 =C4 no A3 abc yes A4 =B3 no A5 bla yes Can anyone give me a hint how to do so? Many thanks in advance regards Julian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting data derived from formula | Excel Worksheet Functions | |||
| Entering Line Breaks in a Title derived by a formula | Charts and Charting in Excel | |||
| Highlight Record and Field | Excel Discussion (Misc queries) | |||
| create formula. 1 field constant and another field varies by inpu. | Setting up and Configuration of Excel | |||
| How do I copy cell values (derived from formula), not references? | Excel Worksheet Functions | |||
Threaded Mode
