Conditional formating of rows when partial word match in E and non-blank in P

This might not be possible, I have tried many, many AND, SEARCH, COUNTIFS, etc possibilities...

The result is easy to explain, but doesn't seem very easy to accomplish.

I would like to use conditional formatting, applied on entire row, when the first word in column E is "Initial" and there is a date, any date (or non-blank) in column P.

Any ideas or hints on how to accomplish this? Might some sort of combination of functions maybe...

Thanks in advance!

Try

in CF

=AND(LEFT($E3,8)="Initial ",$P3<>"")

So selects on "Initialx" where x=blank

Set Applies to:

=$3:$100

I have assumed first row is 3 and last 100.

Thanks for the suggestion, but it doesn't seem to do anything.

Attach a sample workbook.

Make sure there is just enough data to demonstrate your need.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

See attached

Thanks again, I see it does what I'm looking for in your sample but it won't work on my worksheet for some reason. Could it be because the date is populated via VLOOKUP?

i.e. =IF($A3651="","",IFERROR(VLOOKUP($A3651,Sheet1!$A$2:$F$9999,3,0),IFERROR(VLOOKUP($A3651,Sheet2!$B$3:$H$996,7,0),IFERROR(VLOOKUP($A3651,Sheet3!$B$3:$H$993,5,0),""))))

Which cell is VLOOKUP in ? P ?

As requested earlier, post a sample file.

VLOOKUP worked OK for me.

Figured it out, thanks. Did not work because in the source, "Initial" was not followed by a space, but actually "Initials-XXX". I also figured the 8 in the formula refers to the looked up word length including the space after.

Thanks again!