Detect fill colour in cells

[davej311]

I have a conditional formatting that shades cells based on my criteria, however if the cell already as shading I want to leave it as is. How can I do this please?

Thanks

 

[Special-K99]

How is it "already have shading"
If manual shading then you have to use VBA to detect the colour of the cell, you would not be able to do this via Condtional Formatting.
If you're saying the cell is shaded by an existing Condtional Formatting then just use the same condition to detect if the cell is already shaded in your new CF formula.

 

[davej311]

Thanks for your reply, it was manually shaded.

 

[Special-K99]

I'm not an expert on VBA and certainly haven't delved into the "detecting colours" side of VBA

 

[Fluff]

One option.
In Name manager create a name, I've used IsColoured, & in the refers to box put =GET.CELL(63,INDIRECT("rc",FALSE))
Then in you Conditional formatting formula you can use something like
=AND(A1<>"",IsColoured=0)

The workbook will need to be saved as Macro enabled.