Add Text to a cell based on the colour of another

[garwil]

Hi,
I have a column of dates (column 'H'). Some of these dates have been conditionally formated with a fill colour if they are a school holiday. I want to add the words "SH" as a formula in the column alongside (column 'I') if it comes a cell in column 'H' cell that is coloured.
Any ideas as to how this can be achieved as I cannot find anything in the forum..
Many thanks

 

[VoG]

You should be able to adapt your conditional formatting to do that.