Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
conditional formating | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Help Please with Conditional FOrmating | Excel Worksheet Functions | |||
conditional formating.... | Excel Worksheet Functions |