Simple True/False Colouring (Not Conditional)

I'm looking for a slightly better way of doing the following...

Please Login or Register  to view this content.

Hyflex,

I would recommend conditional formatting instead of VBA. highlight column A and create two conditional format formulas:
For the Good style, use this formula: =AND($A1<>"",$A1="True")
For the Bad style, use this formula: =AND($A1<>"",$A1="False")

I do see in your thread title that it says "(Not Conditional)". If it has to be VBA, I'd recommend using autofilter for this operation:

Please Login or Register  to view this content.