I've not had much luck searching for this but it seems like there should be a really simple answer.
I have data in range A1:D600 and I'm attempting to highlight the row based off the data in one cell of that row.
Example:
Acc#, John, Doe, 123 Street, 5551212, NO JOB
If F="NO JOB" then I want all of this row to highlight red.
I'm able to do this if I use conditional formating for each row, however I do not want to have 600 conditional formats. I'm guessing there is an easier way, but I've failed as locating it as of yet.
If it effects anything.. the "NO JOB" line is obtained using this code:
=IF(J10=" ","NO JOB",(VLOOKUP(("*"&(J10)&"*"),I:I,1,FALSE)))
Thanks.
I have data in range A1:D600 and I'm attempting to highlight the row based off the data in one cell of that row.
Example:
Acc#, John, Doe, 123 Street, 5551212, NO JOB
If F="NO JOB" then I want all of this row to highlight red.
I'm able to do this if I use conditional formating for each row, however I do not want to have 600 conditional formats. I'm guessing there is an easier way, but I've failed as locating it as of yet.
If it effects anything.. the "NO JOB" line is obtained using this code:
=IF(J10=" ","NO JOB",(VLOOKUP(("*"&(J10)&"*"),I:I,1,FALSE)))
Thanks.