So I would like to automate the following, as doing it by hand takes a lot of time. Is it possible? I have searched the whole internet and finished empty handed.
Start from cell E10
Select cell
Move 3 cells down
Select cell
Move 3 cells down
Select cell
Move 3 cells down
Select cell
Move 3 cells down
Select cell
Move 3 cells down
Select cell
Move 3 cells down
Select cell
Apply double entry conditional formatting
Move 3 cells down
Repeat above until cell E5000
try this macro . what do you ant to do after selecting each cell
Please Login or Register to view this content.
I am not an expert. better solutions may be available
[email protected]
Hi, ×_×,
you may get the code to insert as Conditional Formatting by recording a macro when you iunsert this into a single cell and compare if this matching with the code applied here:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thank you for the replies.
HaHoBe: This seems to be what I am looking for. But now the key question remains: how can I make it apply the conditional formatting to each group of 6 cells?
Hi, ×_×,
you would need to pass on more information than just
which isn´t a key question but a new and different one to me as the starting post of this thread.But now the key question remains: how can I make it apply the conditional formatting to each group of 6 cells?
Please Login or Register to view this content.Ciao,Please Login or Register to view this content.
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks