View original (French)

Color cells based on a value

Tlebourg -  
Hello,

After searching for a while, I can't find a way to solve the issue I'm facing. Let me explain...

I'm looking to color a certain number of cells in a row based on a value entered. For example, if I enter the value 30 in A1, I will have 30 cells (so B1, C1, D1... colored 30 times). Thus, I will just need to enter another value in A1 and the number of colored cells will change.

I hope I have been clear in my request.

I look forward to your response. Thank you.

3 answers

  1.  via55
    Hello

    Select the range B1:ZZ1
    Conditional formatting formula to apply:
    =COLUMN()-1<=$A$1

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    0
    1. Tlebourg
      Oh yes, I see, thank you very much!

      Now that I have this, how could I start the coloring from column B or C and not include the column where I enter the value?

      Thank you for your answers.

      Best regards.
      0
      1. Tlebourg
        My apologies, I found my mistake, thank you very much!

        Is it possible to make it so that I can manually move the colored area once the coloring is done, in the case of an application to a cycle time estimate where I need to regularly move the different actions?

        For example, if I set a cycle time of 2s on two cells B and C, and then I have to move them to F and G, do I have to go back to the conditional formatting rule or redo everything, or is there a simpler way to do it?

        Thank you for the time you are giving me.

        Sincerely
        0