Forum Discussion

Edith_Thornburg's avatar
Edith_Thornburg
Copper Contributor
Apr 26, 2022
Solved

continuing a series question

I have a table with 6 columns for each month, each month alternates either blue or white. I am trying to automate the sequence so that I don't have to type it in each month. I am sure it is an easy f...
excel
Formulas and Functions
  • amit_bhola's avatar
    amit_bhola
    Apr 26, 2022

    Edith_Thornburg , see attached file for example.

     

    Set-up the formula as below.

     

    Formula trend is :-

     

    If Start is from column A, then

    =DATE(2022,FLOOR((COLUMN()-1)/6,1)+3,1)

     If Start is from column B, then

    =DATE(2022,FLOOR((COLUMN()-1-1)/6,1)+3,1)

    If Start is from column C, then

    =DATE(2022,FLOOR((COLUMN()-1-2)/6,1)+3,1)

    and so on...

     

    Once setup, you can drag the formula to the right.

     

    Format the cell as below setting :-

     

    Set up 12 columns manually for color and formula.

    Then select 12 columns, and drag to the right.

    The formula and color shall be filled as you desire.

     

     

     

     

     

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Apr 26, 2022

Edith_Thornburg 

Change the appearance of your worksheet

To change the text fonts, colors, or general look of objects in all worksheets of your workbook quickly, try switching to another theme or customizing a theme to meet your needs. If you like a specific theme, you can make it the default for all new workbooks.

 

 Hope I was able to help you with this information.

 

NikolinoDE

I know I don't know anything (Socrates)

  • Edith_Thornburg's avatar
    Edith_Thornburg
    Copper Contributor
    Apr 26, 2022
    I want 6 columns white, the next 6 blue, then white and so on.
    Also, I want some kind of a formula so that the first 6 columns have the heading Mar 22, the next have Apr 22, the next have May 22 and so on. I didn't think it was a theme kind of thing?

Resources