Conditional formatting transparent color

[dumitrudan608]

Hi,

Is there a way to use a transparent conditional formatting to put a "shade" over cells with true? The result i'm looking for is let's say a cell has already been manually highlighted with a specific color, if the conditional formatting is true, than a color with transparency will be shown over it, so as the initial color would also be visible.

 

[Fluff]

Re: Excel question: Conditional formatting transparent color

You could check if the cell has a background fill & if it does then not the CF will ignore that cell. Would that work?

 

[dumitrudan608]

Re: Excel question: Conditional formatting transparent color

You could check if the cell has a background fill & if it does then not the CF will ignore that cell. Would that work?

Wel that is my problem, i have not found an Excel formula that can return true if cell has a background fill. Can you help me there?

 

[Fluff]

Re: Excel question: Conditional formatting transparent color

On the formula tab select Name Manger > New > give it a name (I've used IsColoured) > in the refers to box put
=GET.CELL(63,INDIRECT("rc",FALSE))
then Ok > close
Then with your Cf formula use
=AND(IsColoured=0,your existing formula here)

 

[dumitrudan608]

Re: Excel question: Conditional formatting transparent color

You are a wonderful human being!

 

[Fluff]

Re: Excel question: Conditional formatting transparent color

You're welcome & thanks for the feedback

 

[RoryA]

Re: Excel question: Conditional formatting transparent color

You could also just apply a pattern using CF so that you can see that CF applies while still seeing the fill colour.

 

[dumitrudan608]

Re: Excel question: Conditional formatting transparent color

@RoryA i tried the patterns, but they are intrusive and make the text barely readable. If the dots were much more fine it would result in transparency and that would be perfect.