Forum Discussion
HMurkin
Mar 02, 2023Copper Contributor
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...
HansVogelaar
Mar 02, 2023MVP
Since you use conditional formatting, you could use the same conditions in your IF or IFS formula.