Conditional formatting-format cell in column based on value in another cell (row by row)

ljwisner

New Member
Joined
Dec 31, 2019
Messages
3
Office Version
  1. 2016
Platform
  1. Windows
I am trying to format (bottom border) each cell in a column based on the value in the corresponding cell in the same row. I can do this individually to each cell, but would like the formatting to "read" the value in a cell, and format another accordingly for the entire column.

For example:
excel snip.PNG

This is my workbook. I am trying to have a bottom border on cells B3-B12, C3-C12, D3-D12 based on the fact that cells A3-A12 have a number in them. I would like the bottom border of B12, C12, D12 to disappear if A12 does not have a number in it. Same goes for B11,C11,D11 if A11 doesn't have a number etc.

I can currently do this by selecting B2>conditional formatting>formula>=$A$2<>"".

I do not want to have to select each cell in the B,C,D columns to then "read" the corresponding A column cell.

Please help.
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

ljwisner

New Member
Joined
Dec 31, 2019
Messages
3
Office Version
  1. 2016
Platform
  1. Windows
=COUNTA($A3:$Ax) will not work because there is a formula to determine if there is a number shown in column A
 

Snakehips

Well-known Member
Joined
May 17, 2009
Messages
5,103
Office Version
  1. 2013
Platform
  1. Windows
Try
Select the range B3:D12 > Cond Format > Formula > =ISNUMBER($A3)


Hope that helps
 

Watch MrExcel Video

Forum statistics

Threads
1,127,100
Messages
5,622,710
Members
415,922
Latest member
gemmatay88

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