Trying to creat a formula the will apply conditional formatting when both conditons occure

[Mstaiano]

Hello,

I have a worksheet and want to apply conditional formatting if one column has a blank for start date but another column lists the account as active. While I can apply each condition separately I can't seem to get them to work together with any results. I have tried using =and(p2="".x2="active"). Excel stops working

[Pepe Le Mokko]

What do you mean "excel stops working"?
Your CF looks right. Perhaps post a sample sheet

[Mstaiano]

cond.format.xlsx

I get a message from excel that I can't use this as a formula. There is a problem or the circle keeps spinning

[Mstaiano]

In this one the column letters will have changed to a2 "" and I2 "active"

[Pepe Le Mokko]

Does the attached help?

[FDibbins]

I have tried using =and(p2="".x2="active"). Excel stops working

1. Not sure what you are trying to do with that 2nd part... =and(p2="".x2="active")
to begin with, you need to use , not . to seperate contitions

2. try this instead...=AND(A2="",I2="Active")

3. Do NOT format the entire column with CF, and dont use full column ranges, it will slow your file down - and could be whats causing excel to crash on you.
Only use the range you need

[Mstaiano]

Thanks for looking at this. I did post a sample below. The columns are changed because I took out some data. Excel says it is not a valid formula

[Mstaiano]

yours works perfectly. I finally got it down to that and it was off by 1 row. I row above. Thank you !! So much!!

[FDibbins]

Just out of curiosity, which 1 worked for you? (I didnt open Pepe's file)

[Mstaiano]

They both work. I believe the file the client gave me has problems as when I apply it to that file instead of the smaller one it works...just offset by one row above. Haven't figured that out yet.
Thanks