| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function to return values for cells with blank or - in them
Hello,
I have cells with either a blank or - in them. The only option for that cell is to have a blank or - in it. I want to write an if statement that will return a value of true and for which I can use conditional formatting to turn the cell a particular color depending on whether it is blank or has a - in it. How can I do that? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function to return values for cells with blank or - in them
=OR(A1={"","-"})
"Daren" wrote: Hello, I have cells with either a blank or - in them. The only option for that cell is to have a blank or - in it. I want to write an if statement that will return a value of true and for which I can use conditional formatting to turn the cell a particular color depending on whether it is blank or has a - in it. How can I do that? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function to return values for cells with blank or - in them
That worked. Thanks!
"Teethless mama" wrote: =OR(A1={"","-"}) "Daren" wrote: Hello, I have cells with either a blank or - in them. The only option for that cell is to have a blank or - in it. I want to write an if statement that will return a value of true and for which I can use conditional formatting to turn the cell a particular color depending on whether it is blank or has a - in it. How can I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| IF function - need FALSE to return a blank cell, not 0 | Excel Worksheet Functions | |||
| Solution for charting IF statements that return blank values | Charts and Charting in Excel | |||
| A function to return the value of a blank cell | Excel Worksheet Functions | |||
| Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions | |||
Linear Mode
