Conditional Formating

[Kanmi]

Hello, I apply conditional formating by using formular to a cell and i want
to apply it to all the cell without re-typing the same formular in
conditional formating pop up window. I mean i tried to clik and drag to the
next cell but it not working because all cell have different formular but i
want the same conditional formating. Thanks

 

[FloMM2]

Kanmi,
Try this:
The conditional formatting that I chose is "Is Cell value" , "greater than",
"5".
All this is done for cell D5.

Select the cell with the conditional format that you want, in my example it
is cell D5.
Select the copy icon, select the range of cells to copy onto.
Then select "Edit", "Paste Special", then select "Formats" and "OK'
hth