Forum Discussion
If statement using cell color
Hi all I am a teacher and have a spreadsheet with topics Red, amber and greened based on assessment marks. I would like to use an IF statement based on the cell color, however I am using conditiona...
Since you use conditional formatting, you could use the same conditions in your IF or IFS formula.