I've been searching around but can't find a way to do this.
If A1 has a value of 1, I want the format of C1 to change to text. I've seen some similar questions but haven't found an answer that works for this situation.
I've been searching around but can't find a way to do this.
If A1 has a value of 1, I want the format of C1 to change to text. I've seen some similar questions but haven't found an answer that works for this situation.
Maybe in the worksheet module
Please Login or Register to view this content.
Hope this helps
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thanks for the help Marcol. I thought it might be a VBA solution, and I know nothing about VBA. I've used this in a test workbook and it works perfectly, but I'm wondering what the VBA equivalent of copying down is. I oversimplified in the initial post; I should have said if the value in column A is 1, I need the corresponding cell in column C to change to text.
For a bit of background: the 1 appears in column A if the name in column B ends in (V), which indicates the person is a visitor (not a member.) Column A is essentially a helper column to determine if the person is a visitor. Visitor's scores don't count for points, and the easiest way I found to have the score ignored in other point-awarding formulas is to change the cell format to text. I have very average Excel skills so maybe I'm not going about this the right way. I'm open to suggestions if there is a simpler way.
This might be the VBa solution, it isn't really a "fill down" solution, it is just that the macro is fired by changing any cell/cells in Column A
Please Login or Register to view this content.
However by your description of your sheet, if you put "V" in column A instead of 1 (no need then to add "V" to the visitors' name) then
will total the members scoresPlease Login or Register to view this content.
will total the visitors scoresPlease Login or Register to view this content.
No need for VBa
Hope this helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks