conditional formatting on formua with another cell

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Dear All,
is it possible to do conditional formatting like:
format all cells in column A where the adjacent cell in Column B is empty?

Conditional formatting always refers only to one cell -> would need the same
functionality as if a formula is dragged down and the references are
automatically counting up

possible?
Br,
Andy
 
Select all of column A, with A1 being active cell. CF formula is:
=$B1=""
Set formatting, ok, out.
 
Back
Top