| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting refferencing another cell
Hi,
I am working in exel 2007. I want to put "good" in cell A1 if cell b1 is less than 60 and if greater than 60 less than 80 i need to put "ok". Please help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting refferencing another cell
Try the below formula in cell A1
=IF(B1<60,"Good",IF(B1<80,"OK","")) If you want to return blank when B1 is blank try the below =IF(B1="","",IF(B1<60,"Good",IF(B1<80,"OK",""))) If this post helps click Yes --------------- Jacob Skaria "Sudipto" wrote: Hi, I am working in exel 2007. I want to put "good" in cell A1 if cell b1 is less than 60 and if greater than 60 less than 80 i need to put "ok". Please help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting refferencing another cell
In the mean while I assume you already know about AppActivate Function which
activates an application that is already running. http://msdn.microsoft.com/en-us/libr...hy(VS.80).aspx If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try the below formula in cell A1 =IF(B1<60,"Good",IF(B1<80,"OK","")) If you want to return blank when B1 is blank try the below =IF(B1="","",IF(B1<60,"Good",IF(B1<80,"OK",""))) If this post helps click Yes --------------- Jacob Skaria "Sudipto" wrote: Hi, I am working in exel 2007. I want to put "good" in cell A1 if cell b1 is less than 60 and if greater than 60 less than 80 i need to put "ok". Please help |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting refferencing another cell
Please ignore the below post on AppActivate
"Jacob Skaria" wrote: In the mean while I assume you already know about AppActivate Function which activates an application that is already running. http://msdn.microsoft.com/en-us/libr...hy(VS.80).aspx If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try the below formula in cell A1 =IF(B1<60,"Good",IF(B1<80,"OK","")) If you want to return blank when B1 is blank try the below =IF(B1="","",IF(B1<60,"Good",IF(B1<80,"OK",""))) If this post helps click Yes --------------- Jacob Skaria "Sudipto" wrote: Hi, I am working in exel 2007. I want to put "good" in cell A1 if cell b1 is less than 60 and if greater than 60 less than 80 i need to put "ok". Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Linear Mode
