If background color then

[Pestomania]

I want to say the following:

If background color of cell = RGB (255, 102, 255) then
Remove Conditional Formatting
Else
End if

 

[Fluff]

Something like

If ActiveCell.Interior.Color = RGB(255, 102, 255) Then
   ActiveCell.FormatConditions.Delete
End If

 

[Pestomania]

Is there a way to autorun it when the background of a cell changes?

 

[Fluff]

Fraid not, there is no in-built way of detecting if the colour of a cell has changed.

 

[Pestomania]

Hmm okay, that's unfortunate. Can it detect if a cell value has changed?

 

[Fluff]

Yes that's possible as long as the cell is changed manually.
What are you trying to do?

 

[Pestomania]

It can run that at any time a cell is changed, check if the background color of the cell is "pink" and then keep it pink.

 

[Fluff]

Are you trying to override the CF if the cell is manually changed to pink?

 

[Pestomania]

Yes. If the cell is manually changed to pink, that should be the priority CF.

 

[Fluff]

In that case it is possible to detect the colour change.
Create a defined name (I called it IsColoured) & in the refers to put

=GET.CELL(63,INDIRECT("rc",0))

Then you can use that in you CF rule like

+Fluff 1.xlsm
	G	H	I
2	SU963450	Surrey	Waverley
3	SX927937	Devon	Exeter
4	TQ316063	East Sussex	Brighton and Hove
5	TQ184113	5	Horsham
6	SU357218	Hampshire	Test Valley
7	SU804602	123	Hart
8	ST775646	123	Bath and North East Somerset
9	TQ138759	Greater London	Hounslow
10	TQ301779	22	Lambeth
11	ST630812	Gloucestershire	South Gloucestershire
12	TQ182849	Greater London	Brent
13	TQ349861	Greater London	Hackney
14	SU152855	Wiltshire	Swindon
15	TQ318889	Greater London	Haringey
16	TQ380916	Greater London	Waltham Forest
17	TQ077951	Hertfordshire	Three Rivers
18	TL329130	Hertfordshire	East Hertfordshire
19	TL588669	Cambridgeshire	East Cambridgeshire
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H2:H32	Expression	=AND(IsColoured<>38,ISNUMBER(H2))	text	NO