• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can you make borders wider in CF

Jack-P-Winner

Jack-P-Winner

Member
In conditional formatting it only gives a few options on how to border cells. Can you make them any wider than what it offers or add double lines around a cell?
 

Attachments

  • borders.jpg
    borders.jpg
    50.7 KB · Views: 7
In short, nope.
I've had some small success where I make the cells regular formatting have the extra wide border, and then my CF checks for when my condition isn't true and has a regular border. That way, when the condition I actually want appears, the CF turns off, and I see the double border. This obviously has limited applications, but it gets the job done sometimes.

I would propose though that since CF is a visual indicator, changing the color of cell/font/border would be an improvement over changing the border's thickness. Much easier to detect.
 
Thanks Luke. I agree with your comments on the color cells, font The border is my OCD kicking in for perfection lol. Dresses things up.

I wonder if you can do a Macro that will put a thick or double border around anything you tell it to do? Hmm
 
You should know by now that we can make a macro do almost anything we want it to. :P
The real trick is making it do something in a repeatable, controlled manner. You could certainly write a script that runs on Worksheet_Calculate, checking cells contents and formatting cells as desired. Downside is that it might take awhile depending on how many cells, and it would disable the Undo method (which may/may not be acceptable).
 
Luke M said:
You should know by now that we can make a macro do almost anything we want it to. :p
The real trick is making it do something in a repeatable, controlled manner. You could certainly write a script that runs on Worksheet_Calculate, checking cells contents and formatting cells as desired. Downside is that it might take awhile depending on how many cells, and it would disable the Undo method (which may/may not be acceptable).
Click to expand...

So true Luke, as individuals we can do ANYTHING we put our minds to and want to learn. I am so blessed for this site and one other in that folks are willing to take the time to teach without a sarcastic attitude or acting like a dictator because you may mess up. You are correct that someone can do whatever they want with a Macro, I am not there YET but spent most of the night and all day today finishing up 1 of my 3000 row by 38 columns by 18 sheets LOL filling in the conditional formatting I needed thanks to Narayan's help I was successful but you are correct it to me many hours but the time it will save me down the road is priceless every time I do a reset it will not adjust on its own (-:
 
You must log in or register to reply here.
Back
Top