Black out certain cells if the column contains X

[ineedthisspread]

Hi Guys,

I think this will be done by conditional formatting but do not know how to represent "This Coulmn" in the formula.

I'm looking for a way if the column reads "XXX" in the top cell to black out the 3 cells below it. and then 9th and 11th cell down.

The cells below cannot contain a formula as they must all be able to contain text.

I can make a conditional format for it to apply to one column but as i need this to work over the whole page but restricted to the text only affecting each own column without having to make a different conditional format rule for each column.

Please can someone help?

Kind Regards

Mark

[Fotis1991]

...I can make a conditional format for it to apply to one column but......

Which is your formula for this?
Which is your range?

[dilipandey]

Hi mark,

Suggest you to upload a sample workbook.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[ineedthisspread]

I am unable to attach a doc but here is a scsample.jpgeenshot of what i mean

[dilipandey]

Hi Mark,

I Used below formula in conditional formatting and seems to be working

Please Login or Register  to view this content.

See attached for more details:- cf in column contains xxx.xlsx


Regards,
DILIPandey
<click on below * if this helps>

[ineedthisspread]

Perfect! Thankyou again Dilipandey!

[dilipandey]

You are welcome Mark..

suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey
<click on below * if this helps>