Conditional Formating

  • Thread starter Thread starter Kanmi
  • Start date Start date
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
 
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
 
Back
Top