| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting on cell with a formula
Instead of using this kind of link formula: =Sheet1!A1
you could try something like this: =IF(Sheet1!A1="","",Sheet1!A1) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Nicole L." wrote: I need some similar help - can you possibly help me? In a cell in a wksheet, it has a formula that pulls the value/words from another worksheet cell. If the cell it's referencing is blank, Excel gives me a "O" in the destination cell. How do I make it give a blank if the referenced cell is empty? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is conditional formatting or formula possible by cell color? | Excel Worksheet Functions | |||
| Recognizing Cell Formatting To Use In A Formula Or Conditional For | Excel Worksheet Functions | |||
| Conditional formatting formula that uses VLookup, based on content of another cell | Excel Discussion (Misc queries) | |||
| Conditional formatting formula that uses VLookup, based on content of another cell | Excel Discussion (Misc queries) | |||
| Conditional Formatting if cell content is a formula | Excel Worksheet Functions | |||
Threaded Mode
