Conditional Formatting For Column Range

User avatar
adam
SilverLounger
Posts: 2347
Joined: 23 Feb 2010, 12:07

Conditional Formatting For Column Range

Post by adam »

Hi anyone,

I have the following formula where I want to remove the borders of column AJ6:AJ41 if cell AJ6 has "16-Dec" using conditional formatting.

I'm only able to remove the bores of cell AJ6 only.

Any help on this would be kindly appreciated.

=TEXT($AJ6, "dd-mmm")="16-Dec"
Best Regards,
Adam

User avatar
HansV
Administrator
Posts: 78351
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional Formatting For Column Range

Post by HansV »

If you want to remove the borders from the entire range if AJ6 contains 16-Dec, change the formula to

=TEXT($AJ$6, "dd-mmm")="16-Dec"

with a $ before the row number 6.

If you want to remove the borders from the cells that contain 16-Dec, you can use a different type of rule:

Select AJ6:AJ41.
On the home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'equal to' from the second drop down.
In the box next to it, enter the formula

=DATE(2023,12,16)

Click Format...
Activate the Border tab.
Click None.
Click OK, then click OK again.
Best wishes,
Hans

User avatar
adam
SilverLounger
Posts: 2347
Joined: 23 Feb 2010, 12:07

Re: Conditional Formatting For Column Range

Post by adam »

Thank you so much for the help.
Best Regards,
Adam