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"
Conditional Formatting For Column Range
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07
Conditional Formatting For Column Range
Best Regards,
Adam
Adam
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional Formatting For Column Range
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.
=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
Hans
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07