Dear all,
Is there a way to change the background color a SPILL range?
I would like to color the background and/or text color of a SPILL range to create a better visual design.
Can do that using conditional formatting but it is unknown how deep the area should be prepared and the calculation is slower.
Thank you very much
LA
CF is the only way I know of doing that. I would use =B2<>"" as the CF formula.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Originally Posted by Glenn Kennedy
Hi,
Thank you for your reply.
I do/did use that for now.
Looking ( read- searching ) right now for some VBA code that can a SPILL Range.
LoL. Don't look in my direction. I have no, zero, zip, stuff-all ability with VBA.
I'll move this to the VBA section.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
hello, you can test it for a cell with range.hasSpill, but it's not very handy.
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Thank you for your info.
Will later tonight looking into this.
Why is it not very handy?
If I check the frist top right cell where the SPILL formula lives in then I should get the result SPILL range, right? Or is there any issue?
AAArch, if I am right you have to select a range and then you will get true or false back if it is a SPILL.
But I found this;
anyway is for later tonight. Need to read it.
Please Login or Register to view this content.
Last edited by lord anubis; 05-01-2023 at 02:14 PM.
Btw, I forgot to mention that If I know the number of columns I could use CountA(Cell#) then divide the answer with the number of columns and I know the number of Rows ( thus also the Range). But ( Vertical SPILL ), in this case, I don't know the number of columns.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks