Basically what I want to do is make the IF statement I've made, green if
active and red if inactive...but stating that it has to be greater than
the number in cell A4 to be active thus green but less than the number
in A4 to be inactive thus red!

How can I do this?

Thanks a lot
From John


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=518819

Select A1 and pull down Format Conditional formatting...
Pick formula is and enter =(A1A4) select a green background
again pull-down conditional formatting and add a second condition
Pick formula is and ente r=(A1<A4) this time select a red background
--
Gary''s Student


"Neo1" wrote:


Basically what I want to do is make the IF statement I've made, green if
active and red if inactive...but stating that it has to be greater than
the number in cell A4 to be active thus green but less than the number
in A4 to be inactive thus red!

How can I do this?

Thanks a lot
From John


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=518819

Under Conditional Formatting select use formula; then

Condition 1=if(A1A4,True,False) Pattern Green
Condition 2=if(A1<A4,True,False) Pattern Red

A1 is the cell you are looking for.

Hope that is what you are looking for


Jonathan9560


Neo1 wrote:
Basically what I want to do is make the IF statement I've made, green if
active and red if inactive...but stating that it has to be greater than
the number in cell A4 to be active thus green but less than the number
in A4 to be inactive thus red!

How can I do this?

Thanks a lot
From John


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=518819

I have a problem I try to use conditional formatting on a worksheet and
pick up a cell from another...and it says it has to be from the same
worksheet is this true?

So what do i need to copy past the cell from the other worksheet to the
worksheet I'm creating the conditional format?

Thanks
From John


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=518819