Conditional formating with currennt conditional formating

[AliMW3]

Hey, thank you in advance for any help you can offer!

1. Trying to make a cell stay blank until another is filled. ( I have tried ISBLANK but I can't figure out how to add it to current AND(True, False)formula with formatting based on another two cells in the sheet. I did not write the AND() formula, I am only working with it: {=IF(AND(H40>E40,I40>E40),"Approve","Deny")}


2. I am trying to get the same sheet to highlight an entire row when the last column (J) gets one of those True,False answers. I can get it to highlight A-C and J but not D-I.
*H-J have separate formula formatting for each column that create data based on items entered into E-G and I have made H and I remain blank until data is entered in their corresponding cells:
{=IF(ISBLANK(E82),"", 7500-F82) } I am just not sure how to get the whole row to highlight instead of just J {cel lvalue = to "DENY" format red fill applies to =$J:$J}

Thank you.

 

[DanteAmor]

I'm lost a little.

You could upload a copy of your file, with 2 sheets, in sheet1 your data and sheet2 an example of colors, to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.