View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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