conditional formatting on formua with another cell
 

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

conditional formatting on formua with another cell
 

in cell A1 Format Conditional Formatting Change drop-down to Formula is
=$B1=""

and select formats.

"Andy" wrote:

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

conditional formatting on formua with another cell
 

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

Luke M
*Remember to click "yes" if this post helped you!*


"Andy" wrote:

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