someone plz help , :)

[mercmannick]

sorry but i am tryin every way i know how.........

i have a worksheet,
that i would like a formula to look at contents in one cell (all text by the way),and if blank look at next cell to the right and if tht is blank format the entire row red, if there is data in the first cell or second cell to leave as is .


also i would like formula to b able to look at cell and if a zero in there then to highlight entire row green,

plz give me a hand , the formulas im tryin at moment are as follows:

=if(cell="",(cell=""),1,0)
=IF(I12=ISBLANK(J12=isblank),1,0)
thanks

 

[mercmannick]

zflex.xls
	H	I	J	K
15	2	3/4TO05B
16	3		AWAITINGDETAILPARTD92550013200/201
17	3		AWAITINGDETAILPARTA57244685204
18	3		HELDDETAILPARTD92550013200
19	3		AWAITINGDETAILPARTA57244685205	0
20	4	3/5TO05B		0
21	4	3/6TO05B		0
22	4			1
23	4	3/6TO05B		0
24	4		.	0
25	5			1
26	5	2/3TOO5B	HELDPRESSURETESTVALVE
27	5	3/6TO05B	.
28	5	2/6TO05B	HELDPRESSURETESTVALVE
29	6	4/4TO05B
30	6
31	10	4/2TO05B
32	13	2/6TO05B	HELDF57454009201
33	13		AWAITINGDETAILPARTF57454009201
34	13		HELDDETAILPARTF57454009201
35	14	4/2TO05B
Sheet2

 

[mercmannick]

can eneone help me on this one,
basically i need to look at col H if it "0" to highlight all rows green

and another formula to look at col i if nothin in there then look at col j and if nothin in there to highlight red all rows

awaiting your expertise in helping me

 

[mercmannick]

ok ive sussed out the formula for evaluating both cells

=IF(O90="",IF(P90="",1,0),0)

how do i now format the entire rows in red with 1 in ?

 

[GorD]

For the formatting red if blank, select the entire row (row 1 in my example)
Format -> conditional format. Select formula is and enter the following formula and select pattern red

=AND(ISBLANK($A1),ISBLANK($B1))......

This earlier post should have explained it. The reason my first formula didn't work is the cells you are using are not truely blank as they contain a formula returning a null string.

You could ammend your formula to =and($o90="", $p90="") as the if statements are not necessary with conditional formating as it looks for a true/false result.

 

[mercmannick]

tht will not work as you are not looking to c if whole row blank, only if row K if it =1 format all row red if =0 leave alone


thnx

 

[GorD]

An example using =and($o90="", $p90="")

If both O90 and P90 are blank entire row is red, similar for o91 and P91 etc. Is that not what you need?

Book1
	K	L	M	N	O	P	Q	R	S	T	U	V
90	1	1	1	1				1	1	1	1	1
91					1
92						1
93					1	1
94							1	1	1	1
95				1
Sheet1

NOTICED you now have 2 threads running on this

 

[mercmannick]

yes tht is it

how did u do it ?

 

[GorD]

Select the entire Row - Row 90 Goto Format ->conditional formatting. Change the first box from Cell Value is to Formula is and in the second box type the formula

=AND($O90="", $P90="")

make sure to include the $ signs as above. Select the red pattern under format. Click okay and that should be it for row 90 and be copyable to other rows with the format painter if needed