Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying conditional formatting
Hi,
I have a row of 5 cells. I want to format them so that when two of the 5 cells are 0 the whole set of cells change color. I used the countif function to do this and it works fine. I now want to copy this conditional format for all 5 cells down the other 50 rows. I have tried the usual paste, paste special, but these do not work. Any help would be appreciated Thank you David Williams |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Conditional Formatting | New Users to Excel | |||
Copying Conditional Formatting formulas | Excel Worksheet Functions | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
Copying Conditional Formatting | Excel Discussion (Misc queries) | |||
copying conditional formatting | Excel Worksheet Functions |