#### mercmannick

##### Well-known Member

- Joined
- Jan 21, 2005

- Messages
- 730

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