conditional formatting on formua with another cell

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
 
L

Luke M

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top