IF Cell or Font is Colour X (eg Red) - Then Return Value or Formula | Cell Colour Formula Excel

Опубликовано: 22 Июль 2024
на канале: Chester Tugwell
3,221
69

👍👍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...
Thank you! 👍👍
Download the featured file (including the VBA code) here: https://bluepecantraining.co.uk/wp-co...

In this Microsoft Excel video tutorial I explain how to perform an IF statement based on a cell or font colour. This can be achieved using the GET.CELL function.

🕰️ Timestamps
00:00 Introduction
00:10 IF based on cell colour
03:30 IF based on font Colour
05:11 Formula update problem
06:42 Conditional format problem

#exceltips #exceltricks