Forum Discussion

Copper Contributor

Jun 20, 2020

Solved

IF Function both in formual and conditional formatting.

Hello, I have already enabled the IF function to correspond to certain values and return text. I have also conditionally formatted the text to colours. When I don't yet have data in the cells be...

excel

SergeiBaklan
Jun 20, 2020
GaryPepperell

Perhaps you mean something like this

IF and CF.xlsx17 KB

peteryac60

Iron Contributor

Jun 20, 2020

GaryPepperell

Gary

You are right - it is difficult to communicate.

If you can attach the document we can look and see!

thanks!

Peter

GaryPepperell
Copper Contributor
Jun 20, 2020
peteryac60

Thanks for your response. I have added in the document.
Maturation Analysis 2020 - 2021.xlsx47 KB
- GaryPepperell
  Copper Contributor
  Jun 20, 2020
  @peteryac6- all sorted now, thank you for looking into this for me though!