Conditional Formatting For Column Range

[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"

[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.

[adam]

Thank you so much for the help.