If cell is black color cell next to it black

[berty2000]

Hi guys

Is it possible by conditional formatting or VBA code to check down a column in "B1:B300" and if any cells are black then color the cells next to it in column "C" and "D" black as well.

Thanks in advance

 

[Peter_SSs]

Are the black cells in B1:B300 themselves black by Conditional Formatting or some other way? If Conditional Formatting then use the same conditions to format the other two columns.

 

[Norie]

How will the cells in B1:B300 have been formatted black?

Manually, with conditional formatting or VBA?

 

[berty2000]

Colours the box with conditional formatting =ISTEXT(B1) only colours the box if text in it, the next two boxes in "C" and "D" I want to colour but will always be empty.

 

[Fazza]

If I understand correctly, use nearly the same formula in columns C:D, just make the reference always to column B. That is, =ISTEXT($B1)

OK?

 

[Peter_SSs]

Or you could make them all exactly the same by removing the existing Conditional Formatting then selecting B1:D300 and applying the CF formula suggested by Fazza
=ISTEXT($B1)

 

[berty2000]

Thanks guys this worked so simple didnt think of referencing back to first column.

Trying to think of VB code to do it but this easier

Cheers guys