How to extend a column conditional formatting to other columns?

[excelos]

Hello

I have a conditional formatting which checks the value of the top cell of a column and accordingly formats the whole column.

The code is:
FORMULA: =$A$1=1
APPLIED TO: $A:$A

The problem is that I want this to work for each of the other columns but the columns already have other static and conditional formatting applied to it so I cannot really copy/paste the formatting.

Is there a way to do that?

Thanks!

 

[GWteB]

Select the columns to be affected and add a CF rule using the formula

=A$1=1

 

[excelos]

Thanks but what do you mean 'the columns to be affected'? Are these the columns that the rule must be checked or the columns where the formatting will be applied?

Because I want to apply the formatting to a particular column but I want the rule to be checked for many columns.

I mean, I have columns where the top cell is sequential days. I want to highlight the whole column Green when the top cell is TODAY().

 

[GWteB]

Thanks but what do you mean 'the columns to be affected'? Are these the columns that the rule must be checked or the columns where the formatting will be applied?

The latter.

Book1
	A	B	C	D	E	F	G	H	I	J
1			29-9-2021	30-9-2021	1-10-2021	2-10-2021	3-10-2021	4-10-2021	5-10-2021	6-10-2021
2
3
4
Sheet1

Cell Formulas
Range	Formula
C1	C1	=NOW()-1
D1:J1	D1	=$C1+COLUMN()-3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C:J	Expression	=ROUNDDOWN(C$1,0)=TODAY()	text	NO

 

[excelos]

Mmm thanks but it does not work.

The data is:

28/09/2021​	29/09/2021​	30/09/2021​	01/10/2021​	02/10/2021​
1​	1​	1​	1​	1​
2​	2​	2​	2​	2​

Today 30/09, the third column should be red. Tomorrow 01/10, the third column should not have any formatting and the fourth column should be red. And so one, as days passes.

Is that possible?

I put the condition =A$1=TODAY() applied to columns A:E. I did not use the ROUNDDOWN, is it necessary?

 

[GWteB]

Post your example using the XL2BB tool like I did (you can download it over here ... ) so we're able to determine where you exactly went wrong.

In my example I used NOW() to get the date, which includes the current time, so the ROUNDDOWN was necessary to eliminate the time element, and as can be seen, it works for me.

 

[excelos]

It would be great to use the XL2BB but unfortunately I cannot install anything on this laptop due to policies. Got the conditional formatting to work though thanks!

 

[GWteB]

OK, glad it's sorted. Thank you for letting me know