Refresh custom formulars that checks background color and output as 1 or 0 (File here

Hey guys!

I'm currently struggling with a small formating code and like to refresh a row of formulas that have a macro for background color check in them.
Unfortunately the refreshing methodes that I found only refresh if a cell value changes, not the background color. I also want to change True and False to 1 and 0 somehow.

Attachment 30489
Attachment 30490

Attachment 30491

Quote:

---

Originally Posted by Schutzhofer

Unfortunately the refreshing methodes that I found only refresh if a cell value changes, not the background color.

---

Yes that's true, I think the best you can do is to do it on selection change as you've attempted but use:

Code:

---

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.EnableCalculation = False
ActiveSheet.EnableCalculation = True
End Sub

---

Quote:

---

Originally Posted by Schutzhofer

I also want to change True and False to 1 and 0 somehow.

---

Just put a double negative (I think it's called a double unary) in front of the function:
=--IsCellColour(A13)

Quote:

---

Originally Posted by p45cal

Yes that's true, I think the best you can do is to do it on selection change as you've attempted but use:

Code:

---

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.EnableCalculation = False
ActiveSheet.EnableCalculation = True
End Sub

---

Just put a double negative (I think it's called a double unary) in front of the function:
=--IsCellColour(A13)

---

Yes absolutely. And yes it works like a charm, just like I wanted.
I can extend on that, thank you! :)