IF Formula Based on CELL COLOUR Using VBA Function

[@rpross1986]

Bravo!! VBA Excel Sheets for the win! Ty for the simple code examples

[@emilyandnugget2058]

Hi this was a very helpful tip, however it doesn't seem to work with conditional formatting. Have you every noticed this and found a solution?

[@antonisapergis1260]

Mr. Tugwell your video is very helpful. I only have one problem. After setting the calculation command on the vba, I cannot copy and paste in the sheet. Is there a solution? Thank you in advance.

[@EdMarbach]

Just starting to learn VBA. Your example is close to my needs, but instead I'm trying to search for specific text in a cell and change color and strikethrough for just that portion of text. For this string "N1229A, N1499A, N1709A" I need to change only N1499A to blue and strikethrough. Can you help?

[@vasileios_giannakidis]

Hey Chester. What a helpful video. However, if you could help me please as I am going to break my mind. I want to know how I can write commands to clear contents from specific cells for example a1 to a7 if a8 says No. Please help!!!!

[@marinacicchi3272]

Hi Chester - Is it possible to do something similar but instead of using it as a formula, to format a current file? I have an excel file that was created with cells in different colours (instead of text) - but it was done manually through time so no conditional formatting applied. For example an orange cell means X a green cell means Y - now what i am trying to do getting the cell to say X or Y based on the colour - is that possible? to analyse the full excel worksheet and change the colours for text? Thank you

[@omarkouatli828]

what if conditional formatting is changing my cell color? It doesnt work anymore

[@lyndseychristman9071]

Mr. Tugwell, thank you so much for the video! I do have an issue I am running into though and am hoping you can help. I created the calculate code for my worksheet and it updates my calcs once the color changes, however, when I close out of the spreadsheet and go back in, any changes I make to the colors are not automatically updating. I have to go back into VBA and essentially refresh the code for it to start automatically re-calculating again. Any ideas?

[@ankurbajaj84]

Sir , video is helpful but when I am using the same function wherein if two cells are same color if statement runs .. it works however when I undo color to white or change colour which is not true, Then it does not update the false condition. Pls cna you help

[@SynfinityMSP]

Awesome vid

[@archanaaa2514]

Hi sir, is vba is more demand or python? Which is useful most in future?

[@ChesterTugwell]

Python

[@Joda-es5xd]

Afternoon Sir, I created a VBA that when executed, would use ifs statements and copy and paste from the master data tab to the specific tabs in the same workbook. In other words, the Master Data is the entry form and then the VBA does the sorting and copying of the entire row Data and copies it to the specific tabs. My workbook has a total of 5 tabs, the issue I have is, every time the VBA is run, it duplicates the same data and any new data that was added. Do you think maybe you have a code or video that can be used to illustrate, so it does not duplicate the data or correct this issue, please advise?

[@ChesterTugwell]

I am afraid I don't have a video that deals with that. You are obviously copying all records rather than just the new one. Assuming that the new records is the last row you enter in your data sheet, you will be able to use VBA to copy that row.

[@IvanCortinas_ES]

Calculate doesn't work smoothly. Sometimes it does not update !!