If the car traffic is light enough, and drivers considerate enough, you don’t even need the paint.

To achieve that you need to block roads so cars cant go through neighborhoods, and employ traffic calming road designs, so the only car traffic is slow and people who actually live there or visiting someone who lives there; and need enough people cycling so encountering a cyclist isn’t an unusual or unexpected event… (And for that you need propper separated cycle paths between neighborhoods/destinations/public transport with cycle parking)