Change number format based on cell value | Excel Off The Grid

[@ledow119]

Your formulas ideas more advanced!

[@ianl1052]

More Excel magic. Liked and subscribed. Thanks for your time and effort.

[@ExcelOffTheGrid]

Thanks - I’m so glad you found it useful.

[@ianl1052]

@@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. 🤣🤷‍♂️

[@IvanCortinas_ES]

As always, a great analysis of the case. Thank you very much for this complete example of formats.

[@ExcelOffTheGrid]

Thanks Ivan, I'm glad it was useful 👊

[@kebincui]

Creative as always❤

[@ExcelOffTheGrid]

Thank you! Cheers! 😁

[@usmanahmad7758]

Please tell the pros and cons of applying TEXT function and applying Conditional Formatting. Thanks

[@ExcelOffTheGrid]

That's covered in the blog post.

[@Al-Ahdal]

Excellent Approach for this particular issue. My First Comment!

[@ExcelOffTheGrid]

Thanks for watching! 😁

[@johnboffin476]

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)