How to highlight cells and rows dynamically inside an area?

[Tirrazo]

Hi

I could not find any similar post and wonder if there is an easy way to solve this.

Attacking my workbook which I want the rows and columns from the cell I am standing at to highlight in a chosen color.


Kind regards
Kristian

[maras_mak]

Try it as in the attachment - with conditional formatting.

[Tirrazo]

Thank you!

I think there are some problems with the language. A few words I don't understand and my Excel doesn't recognize.

Is it possible you could try it in english and I translate to my language?

Kind regards
Kristian

[maras_mak]

Perhaps as below formula CF

Please Login or Register  to view this content.

[Vraag en antwoord]

Column must be col

[Tirrazo]

Now it works! Thank you

[Tirrazo]

When choosing a color when formatting the cells, it's overlaying the other colors in the sheet.
Is it possible to have an effect that makes the underlying colors slipping through the formatting color? It would be like the formatting is transparent, but still showing the lines of the rows and cells.