Please tell the pros and cons of applying TEXT function and applying Conditional Formatting. Thanks
@ExcelOffTheGrid6 ай бұрын
That's covered in the blog post.
@ianl10524 ай бұрын
More Excel magic. Liked and subscribed. Thanks for your time and effort.
@ExcelOffTheGrid4 ай бұрын
Thanks - I’m so glad you found it useful.
@ianl10524 ай бұрын
@@ExcelOffTheGrid I've just took a closer look at your file and recreated it "in my own image". Basically kept everything on one sheet, grouped and hid the "data" columns when I didn't need them anymore. Originally, I tried to recreate it from the Data tab and From Picture (screenshot). I felt like a right pratt when I couldn't get anything to work. Then I downloaded your file and saw the reason for my failure. 🤣🤷♂️
@Al-Ahdal6 ай бұрын
Excellent Approach for this particular issue. My First Comment!
@ExcelOffTheGrid6 ай бұрын
Thanks for watching! 😁
@ledow1196 ай бұрын
Your formulas ideas more advanced!
@johnboffin4766 ай бұрын
Hello Sir, I am building a spreadsheet with 7 columns and 2500 rows. Column A is just a reference column, B is dates column which are fine, column C is with Validation drop down codes list for transaction, column D is of transaction details with drop down, tested and working all down to 2500 rows. Column E is payments and F is Income, G is balance (Balance column work as it should) now I need your input in column E and F, If I select from column C (Codes Drop Down List) for Sales, Refund, Finance or Cash Back The entry should only allow me the income column which is column F and if selected payment (Transaction) from C column (Codes) it should allow me to enter in column E "payments column". I have 4 source of income and payments I have about 44 or it may grow prior (My code list and details list grows as it should). I need help using validation (Custom) in these two columns E & F, so that the entry don't get switched between two column E & F. dependent from column C drop down, Your help will be appreciated and thanks a lot if you could help.. (I use Excel 2000)
@kebincui6 ай бұрын
Creative as always❤
@ExcelOffTheGrid6 ай бұрын
Thank you! Cheers! 😁
@IvanCortinas_ES6 ай бұрын
As always, a great analysis of the case. Thank you very much for this complete example of formats.