Conditional Formating
 

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

Conditional Formating
 

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

"Kanmi" wrote:

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