In A1 use the Conditional Format 'Formula Is':
and apply your formatting. Then in A1 click the Format Painter button ('paint brush') then select all relevant cells in Column A to copy the format.
Surface Pro (2017) vs Surface Pro 4
Where HTML5 is headed next
MacBook Pro v Surface Pro 5
Synology invites you to visit them at Insomnia on 26th – 29th August. Book your tickets now and visit Synology.