Finally, I found the solution by making a conditional formatting for one cell as I want it to be. Then, use the format painter after selecting the required cell. Then highlight all the area that I want to have the same CF. However, when you write the equation in the first message box, be sure to remove the ($) sign.