| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting/non blank cells
Hello,
(Excel 2007) I am trying to format a cell based on another cell being "non blank". I thought the non blank formula was "<" but it's not working, e.g. =$E$2="<" This =$E$2="" works for blank cells but I need it to be "non blank". Thank you for your help, Caroline |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting/non blank cells
=$E$2<""
-- Gary''s Student - gsnu200812 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting/non blank cells
Caroline wrote:
Hello, (Excel 2007) I am trying to format a cell based on another cell being "non blank". I thought the non blank formula was "<" but it's not working, e.g. =$E$2="<" This =$E$2="" works for blank cells but I need it to be "non blank". Thank you for your help, Caroline =$E$2<"" |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting/non blank cells
Use
=$E$2<"" Two double quotes without anything in between to represent blank. Or use =ISBLANK($E$2) Be careful with absolute references if you are going to use this over multiple cells. "Caroline" wrote: Hello, (Excel 2007) I am trying to format a cell based on another cell being "non blank". I thought the non blank formula was "<" but it's not working, e.g. =$E$2="<" This =$E$2="" works for blank cells but I need it to be "non blank". Thank you for your help, Caroline |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting/non blank cells
NOT ISBLANK($E$2)
"Sheeloo" wrote: Use =$E$2<"" Two double quotes without anything in between to represent blank. Or use =ISBLANK($E$2) Be careful with absolute references if you are going to use this over multiple cells. "Caroline" wrote: Hello, (Excel 2007) I am trying to format a cell based on another cell being "non blank". I thought the non blank formula was "<" but it's not working, e.g. =$E$2="<" This =$E$2="" works for blank cells but I need it to be "non blank". Thank you for your help, Caroline |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Not Blank Cells | Excel Discussion (Misc queries) | |||
| HELP - Conditional Formatting Dates & Blank Cells | Excel Worksheet Functions | |||
| Conditional Formatting - allowing for Blank Cells | Excel Discussion (Misc queries) | |||
| using conditional formatting - blank cells | Excel Discussion (Misc queries) | |||
| Conditional formatting blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
