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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy conditional formatting
Make sure that your formula use absolute column and relative row for the cell reference, like
=$Z2 < .... and not =$Z$2 < .... -- HTH, Bernie MS Excel MVP "Pammy" wrote in message ... 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? |
Reply |
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 |