Conditional Formatting problem

N

Neo1

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

How can I do this?

Thanks a lot
From Joh
 
G

Gary''s Student

Select A1 and pull down Format > Conditional formatting...
Pick formula is and enter =(A1>A4) 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
 
J

jonathan9560

Under Conditional Formatting select use formula; then

Condition 1=if(A1>A4,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
 
N

Neo1

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
 
Top