Conditional Formatting based on the value of a merged cell

[Gilt Lorn]

I'm trying to figure out how to conditionally format a column of cells based on the value of an adjacent column of merged cells. Each adjacent cell consists of four merged cells.

So basically, if the merged cell is 0 or blank, I would like the adjacent cells to also be blank.

 

[JoeMo]

I'm trying to figure out how to conditionally format a column of cells based on the value of an adjacent column of merged cells. Each adjacent cell consists of four merged cells.

So basically, if the merged cell is 0 or blank, I would like the adjacent cells to also be blank.

Conditional Formatting doesn't change the value of a cell it is applied to, only its format. You need a formula in the adjacent cells to do that. Are the 4 merged cells in a row or a column?

 

[FDibbins]

Further to what Joe said, the contents of merged cells is always in the top-left cell.

If A1:A5 is merged the contents is in A1
If A1:E1 is merged the contents is in A1
If A1:E5 is merged the contents is in A1

So your test, in these cases, would always be for A1

 

[Rick Rothstein]

Conditional Formatting doesn't change the value of a cell it is applied to...

True if the OP meant the cell's value should physically be the empty string (""), but if all the OP was wanting is for there to be no visible displayed value in the cell even if there was some physical value in it, then a Custom Format of ;;; (three semicolons) within the would hide the physical value in the cell and display what looked like a blank cell. The OP's wording was just a little too vague to know which he actually wanted.