' ' Process a column of values, colouring alternate ranges of the same value. ' ' Work down a column of cells, stopping when a blank is hit. ' ' If a cell is a different value to the one preceding it, invert the ' value of the toggle variable. ' ' If the toggle variable is true colour the cell. ' Public Sub main() Dim w As Worksheet Set w = Worksheets("Sheet1") Dim rowCtr As Integer rowCtr = 2 Dim toggle As Boolean toggle = False While w.Cells(rowCtr, 1).Value <> "" If rowCtr > 2 Then If w.Cells(rowCtr, 2).Value <> w.Cells(rowCtr - 1, 2).Value Then toggle = Not toggle End If End If If toggle Then With w.Cells(rowCtr, 2).Interior .ColorIndex = 6 .Pattern = xlSolid End With End If rowCtr = rowCtr + 1 Wend End Sub
…a fictional 2006 FIFA World Cup Finale between Germany and Netherlands. When the team from Germany loses, they send out as revenge a Zombie invasion
Why? God dammnit why?
The definition of the Dunning-Kruger effect, aken from Wikipedia:
…is a cognitive bias in which “people reach erroneous conclusions and make unfortunate choices but their incompetence robs them of the metacognitive ability to realize it”…
Which can be summarised as:
The trouble with the world is that the stupid are cocksure and the intelligent are full of doubt.
This explains a lot, don’t you think?
Homeopathy is an ancient, pre-scientific and absurd pseudoscience. Yet it persists today as an accepted complementary medicine, largely because people don’t know what it is.
The 10:23 Campaign aims to show the public what homeopathy is and explain how we know it doesn’t work.
The most interesting, not to mention entertaining, proponents of the Apollo Hoax theory are:
- Bill Kaysing – the “father” of the Apollo hoax theory.
- Ralph Rene – conspiracy theorist and ardent hoax supporter.
- David Percy and Mary Bennet
- Marcus Allen
- Bart Sibrel – conspiracy theorist, ardent hoax supporter and film maker. He was famously punched by Buzz Aldrin after accusing the astronaut as being “a coward, a liar and a thief” – see the youtube video here.