Back to Browse

IF Formula Based on CELL COLOUR Using VBA Function

28.0K views
Jul 15, 2020
7:16

πŸ‘πŸ‘If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ Thank you! πŸ‘πŸ‘ This video demonstrates how to write a VBA function that will return TRUE if a specified background colour has been applied to a cell. The VBA function can be used as the logical test in an IF statement. If you would prefer a non-VBA solution please see https://youtu.be/WeUrO7YENSg The video will be useful if you are asking the following questions: Can you do an IF statement in Excel based on color? IF cell colour is red, then.... ------------------------

Download

0 formats

No download links available.

IF Formula Based on CELL COLOUR Using VBA Function | NatokHD