Forum Discussion

Copper Contributor

May 19, 2022

Same condition for a set number of columns

I have a set of columns that have exactly the same condition but each one is independent to the other , which means whenever i want to change a parameter in a column i will have to make the change th...

excel

Formulas and Functions

office 365

HassanBosha

Copper Contributor

May 19, 2022

Martin_Weiss

Here i have the exact same condition for specific set of columns each has 3 condition but they all have the same condition with the same parameters

Can i put like comma between the range of the colomn in "applies to" cell or what can i do ?

Martin_Weiss

Bronze Contributor

May 19, 2022

Hi HassanBosha

sorry, I was not aware that you are speaking about formatting rules.

What exactly is it, that you need to change in these rules?

Is it the "30" in formula =TODAY-G8<30?

Or what is the parameter that you need to change?

HassanBosha
Copper Contributor
May 19, 2022
Martin_Weiss
Yes Mainly the 30 in all conditions in all columns that has similar formulas but different column names
- Martin_Weiss
  Bronze Contributor
  May 20, 2022
  Hi HassanBosha
  
  ok, then I propose you put the variable value 30 in a cell in your worksheet, let's say in A1. And then you have to change the conditional formatting rules to refer to that cell.
  
  So, instead of
  =TODAY-G8<30
  you write
  =TODAY-G8<A1
  
  Of course, it's time consuming to change all rules, but after that, you just need to change the value in A1 and it will be applied to all rules referring to that cell.