In this video, I explain how to automatically format hard-coded values as blue in Excel. There is no button to automatically format hard-coded values blue in Excel, so you have to use conditional formatting to do it.

The conditional formatting formula is =and(not(is formula(a1)),is number(a1))

Please take the opportunity to connect and share this video with your friends and family if you find it useful.