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

H_gupta

New Member
Joined
Mar 26, 2019
Messages
31
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
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,803
Office Version
  1. 365
Platform
  1. Windows
How about
+Fluff 1.xlsm
BCDEFGHI
1
208 2021y
312 2021y21
410 2021ya
509 2021y
6plll3
7
8
Main
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B2:I8Expression=AND(B2="",COUNTIF($B2:$I2,"<>"))textNO
 

H_gupta

New Member
Joined
Mar 26, 2019
Messages
31
How about
+Fluff 1.xlsm
BCDEFGHI
1
208 2021y
312 2021y21
410 2021ya
509 2021y
6plll3
7
8
Main
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B2:I8Expression=AND(B2="",COUNTIF($B2:$I2,"<>"))textNO
worked like a charm ! thanks a lot :)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,803
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,128,163
Messages
5,629,060
Members
416,363
Latest member
zaveedd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top