Color cells based on a value
Tlebourg
-
Tlebourg -
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.
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 réponses
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
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
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.
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.
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
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