Conditional formatting help

[xryanx]

I need to have J29:J215 filled red or K29:K215 filled red if J29:J215 is blank and there is a value in that row (A29 or K29 or Etc...)

I tried conditional will all values that are blank, but all the cells below the rows that I have data get filled. I only need the the fill when the cell in column J doesn't have a value and the rest of the cells in that row do have values.

Below is my spread sheet.

	A	B	C	D	E	F	G	H	I	J	K
28	Date	SP	Location	Date of Repair	Referral #	Name	Vehicle	Date of Replace	$$$
29	1/1/2018	RK	NEL	1/1/2017	6549876549	johnson johnson and	2018 ford expedition	12/30/2018	$250.00
30	2/2/2018	DR	LV	12/2/2017	321321	bobb			$220.00
31	2/5/2018	RK	NEL	6/16/2017	3213	hello			$300.00
32	3/3/2018	HS	308	12/12/2017	32222	321321		1/2/2019	$190.00

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"></colgroup><tbody>
</tbody>

 

[FDibbins]

What formula did you try?

I would think something like = and($J29="",$A29<>"") might work?

 

[xryanx]

Thank you. That worked perfectly!

 

[FDibbins]

Good stuff, happy to help