Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy conditional formatting
I have a spreadsheet and in col z if I add a date, I want the entire line to
change font color to blue, if nothing in cell remain black, the conditional formatting is: if formula = z##### font color to blue. My question when I right mouse click on the handle in cell a##### and drag down and choose formatt only - the font changes to blue for all the rows, even when cell z#### is blank and should be black until something is typed in that cell. Can you copy the conditional formatting or do you have to set it up in each cell? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
... Can I Copy Conditional Formatting... | Excel Discussion (Misc queries) | |||
Copy Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy Paste Conditional Formatting | Excel Discussion (Misc queries) | |||
copy conditional formatting | New Users to Excel | |||
How to copy conditional formatting | Excel Worksheet Functions |