excel conditional formatting

[Nikhil2803]

Hi Team, I have the below sheet with some conditions. If I put value in D column(name), then col B and C should be highlighted as RED. user has to either type values in Col B or Col C(only one col), if you see the 5th row, this is the expectations. In row 6, if I am giving values in col C, its working. IF I try to give values in Col B, its not working, It should also work as row 6. Below are the formatting code for both col.

for B : =AND(COUNTA($C5:$V5)+COUNTA($X5:$AZ5)>0,ISBLANK($C5))

For C : =AND(COUNTA($C5:$V5)+COUNTA($X5:$AZ5)>0,ISBLANK($C5))

Any leads on this will be highly appreciated

 

[dreid1011]

Give this a try:

Book1
	A	B	C	D
3	message	a id	Employee ID	Last Name
4		11		ss
5			1	sd
6				sd
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:C6	Expression	=AND($B4="",$C4="",$D4<>"")	text	NO

 

[Nikhil2803]

Give this a try:

Book1
	A	B	C	D
3	message	a id	Employee ID	Last Name
4		11		ss
5			1	sd
6				sd
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:C6	Expression	=AND($B4="",$C4="",$D4<>"")	text	NO

There are many columns like D. It will be helpful if you provide your inputs from the code which I have written

 

[dreid1011]

There are many columns like D. It will be helpful if you provide your inputs from the code which I have written

I'm not sure what you mean. Does it apply to columns X:AZ? Your original description does not mention why those columns should be included in the CF formula. It would be beneficial to us both if you explained in full detail what you want.

Hi Team, I have the below sheet with some conditions. If I put value in D column(name), then col B and C should be highlighted as RED. user has to either type values in Col B or Col C(only one col), if you see the 5th row, this is the expectations. In row 6, if I am giving values in col C, its working. IF I try to give values in Col B, its not working, It should also work as row 6. Below are the formatting code for both col.