This post has been de-listed (Author was flagged for spam)
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
In A1:Z999 I have values. The end of the value block is signaled by a closing bracket ( } ) somewhere in column A.
What I would like is for conditional formatting to freak out and display red somewhere if the closing bracket in column A is not connected to the value in A1.
What do I mean by connected? I mean that if I clicked on the closing bracket in Column A, wherever it is, and did control A, it would either select the entire worksheet, or not select the value in A1.
This means that if there's an accidental line break in a block of code, or a block of code is incorrectly formatted, then the CF should throw an error telling me that the closing bracket is not "connected" with a string of non-blank adjacent cells to A1
Subreddit
Post Details
- Posted
- 2 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...