I'm trying to make a continuous color pattern down about 60 rows. For example Row1=Red, Row2=Blue, Row3=Green, Row4=Red, Row5=Blue, Row6=Green, ect., any help here? (I don't want to have to do it manually because another 180 rows will be added soon, with the same color pattern)
Select the first three rows and drag down the fill handle.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks