hi,
i often present my data in a format like in the attached picture. However if i need to insert a row in, the colour coding goes out of sequence. (i.e. 2 blues in a row)
what is the quickest way to recover the pattern?
is it to take a copy of the table in format and paste format over again?
Last edited by devil84; 08-20-2022 at 05:21 AM.
If you use a Structured Table, with row and column striping, it should adjust automatically.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Or you could use conditional formatting on your range
Condition 1 formula
=MOD(ROW(),2)=0
Then choose your format colour for even rows
Condition 2 formula
=MOD(ROW(),2)=1
Then choose your colour for odd rows.
When you insert, formatting adjusted automatically.
Originally Posted by Croweater
thanks - that looks interesting. can you show me example in an excel workbook, so i can look at what needs to be done in Excel
See attached
thank you so much. how do i get to that point though > (i.e. i want to try myself)
do i click on
1) conditional formatting
2) New rule
3. Format cells based on their values?
Yes. Select the range you want to format first. But not "based on their values". Choose the Formula option at the bottom of the list.
binggo. got it
thank you so much.
You're welcome. Thanks for the rep.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
WOW! Now I know how people accumulate those precious rep. points!You're welcome. Thanks for the rep.
@devil84: should have said, the credit should all be to Croweater. The solution was his not mine. I just dropped it into a workbook for you. Please +rep him if too you have not already done so.
ah - sorry thanks Croweater too for the forumlae advice. i can't seem to give reputation twice on same thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks