highlight all other cells in a row if any one cell has a value

[H_gupta]

Hi,

I want to Highlight all other cells in a row which are BLANK, if any one cell of that row has a value
This is to prompt users to enter value in other cells of the row too.

For eg : Cell D25 has value, then Row (B25:I25) should be highlighted except cell D25, and as I keep entering value in the cells B25, C25 etc. they should change to default colour.
Only blank cells should remain highlighted

Tried using conditional formatting with formula : =AND($B25<>"",C25="")
but that highlights the entire row based on first cell

 

[Fluff]

How about

+Fluff 1.xlsm
	B	C	D	E	F	G	H	I
1
2	08 2021	y
3	12 2021	y	2				1
4	10 2021	y			a
5	09 2021	y
6			p	l	l	l		3
7
8
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:I8	Expression	=AND(B2="",COUNTIF($B2:$I2,"<>"))	text	NO

 

[H_gupta]

How about

+Fluff 1.xlsm
	B	C	D	E	F	G	H	I
1
2	08 2021	y
3	12 2021	y	2				1
4	10 2021	y			a
5	09 2021	y
6			p	l	l	l		3
7
8
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:I8	Expression	=AND(B2="",COUNTIF($B2:$I2,"<>"))	text	NO

worked like a charm ! thanks a lot

 

[Fluff]

You're welcome & thanks for the feedback.