Conditional Formating

K

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top