Press the Enter key after and be sure to change B2 and the word TheWindowsClub with your own text. When it comes down to using a Function instead, then we choose to use CONCAT all over again, but ...

Look to the Ribbon and find the Fill Color button. Choose your color and right away the cell will change. You can do the same with fonts by selecting the Font Color icon.

That cell’s fill color is set to Cyan (a neon blue). rngOld, which is the previous active cell is set to nothing—in effect, removing the temporary format. Finally, rngOld is set to Target.