Download the featured file (including the VBA code) here: https://bluepecantraining.co.uk/wp-content/uploads/2024/07/If-Based-on-Colour.zip

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