Conditional formating with currennt conditional formating

AliMW3

New Member
Joined
Jan 25, 2019
Messages
1
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.
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,723
Office Version
2007
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,122
Messages
5,466,824
Members
406,500
Latest member
Tknotmaxx

This Week's Hot Topics

Top