Conditional Formating

[Tazzbjs]

I am looking to add some conditional formatting, but not sure how to make this one work...

What I need is, if the cell in column A has a date, highlight only blank cells in that row (columns C-BE). As data is added to those cells they would no longer be highlighted.

Below is what the sheet looks like.

 

[etaf]

what else can be in column A ?

Select C2:BE1000 (or however many rows you have)

then a formula

=AND( $A2 <> "", C2="" )

Book7
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2	2/1/23
3	2/2/23			1		a		b		b
4
5	2/4/23			12									38
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:N5	Expression	=AND($A2<>"", C2="")	text	NO

 

[Tazzbjs]

Thank-you. That worked great!

 

[etaf]

you are welcome