Forum Discussion
kerl1971
Mar 04, 2024Copper Contributor
Excel Convert to Range Not Working
I'm trying to disable table functionality in a spreadsheet. It's pretty extensive. So, I do not what to have to delete everything and start over. I've tried the Table Design>Tools>Convert to Range, b...
- May 05, 2022a custom formula in conditional formatting will apply the formula to the top left most cell in the 'Applied to' range and then move to each other cell in the range and adjust the formula relative to that next cell location. So lets pretend the gray columns are A:B and you highlight columns C:I and create new rule. Then Enter:
=ISNUMBER(C1)*((C1>$A1)+(C1>$B1))
So C1 is the top left corner of the range so If C1 is a number AND > either A1 or B1 it is true
Then when excel looks at D1 it replaces each C1 with D1 in the formula but the $ before the A and the B tell it to Lock them and not change. And similar when it goes to row 2 all the 1s become 2s.
kerl1971
Mar 04, 2024Copper Contributor
I may have found a work around. I copied the table and pasted the formulas on a different worksheet and deleted the corrupted table. That seems to have fixed the issue.
Thanks!
Thanks!