| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel, how to copy conditional formats in sequential order 1,2,3
here is the formula I am using =NOT($Z$5=")
how do I copy or drag the formula down and have it change to =NOT($Z$6=") then copy or drag it to change in the rows following each other to =NOT($Z$7=") =NOT($Z$8=") and so on |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel, how to copy conditional formats in sequential order 1,2,3
Take a look at "The difference between relative and absolute references"
in XL Help. One way: =NOT($Z6="") In article , ShoDan wrote: here is the formula I am using =NOT($Z$5=") how do I copy or drag the formula down and have it change to =NOT($Z$6=") then copy or drag it to change in the rows following each other to =NOT($Z$7=") =NOT($Z$8=") and so on |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel, how to copy conditional formats in sequential order 1,2,3
Remove the $$ from the cell reference:
=NOT(Z6="") HTH Kostis Vezerides On Jul 3, 2:30 pm, ShoDan wrote: here is the formula I am using =NOT($Z$5=") how do I copy or drag the formula down and have it change to =NOT($Z$6=") then copy or drag it to change in the rows following each other to =NOT($Z$7=") =NOT($Z$8=") and so on |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel, how to copy conditional formats in sequential order 1,2,3
The $ sign stops it changing so remove the dollar sign from in front of the
number and drag away. Mike "ShoDan" wrote: here is the formula I am using =NOT($Z$5=") how do I copy or drag the formula down and have it change to =NOT($Z$6=") then copy or drag it to change in the rows following each other to =NOT($Z$7=") =NOT($Z$8=") and so on |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel, how to copy conditional formats in sequential order 1,2
Thanks
"vezerid" wrote: Remove the $$ from the cell reference: =NOT(Z6="") HTH Kostis Vezerides On Jul 3, 2:30 pm, ShoDan wrote: here is the formula I am using =NOT($Z$5=") how do I copy or drag the formula down and have it change to =NOT($Z$6=") then copy or drag it to change in the rows following each other to =NOT($Z$7=") =NOT($Z$8=") and so on |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel, how to copy conditional formats in sequential order 1,2
Thanks,
That worked "JE McGimpsey" wrote: Take a look at "The difference between relative and absolute references" in XL Help. One way: =NOT($Z6="") In article , ShoDan wrote: here is the formula I am using =NOT($Z$5=") how do I copy or drag the formula down and have it change to =NOT($Z$6=") then copy or drag it to change in the rows following each other to =NOT($Z$7=") =NOT($Z$8=") and so on |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel, how to copy conditional formats in sequential order 1,2
Thanks Mike that worked
"Mike H" wrote: The $ sign stops it changing so remove the dollar sign from in front of the number and drag away. Mike "ShoDan" wrote: here is the formula I am using =NOT($Z$5=") how do I copy or drag the formula down and have it change to =NOT($Z$6=") then copy or drag it to change in the rows following each other to =NOT($Z$7=") =NOT($Z$8=") and so on |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge text in sequential order | Excel Discussion (Misc queries) | |||
| Creating a list in sequential order | Excel Worksheet Functions | |||
| How do I copy conditional formats so it changes cell references? | Excel Worksheet Functions | |||
| data from one sheet to several in sequential order! | New Users to Excel | |||
| How to create Conditional Formats that "grow" with copy/fill down. | Excel Discussion (Misc queries) | |||
Linear Mode
