Forum Discussion
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 below and adjacent it returns a blank cell (IFERROR used). Now when I do this it assumes one of the IF function of < Cell Value and returns the text. However when the cell is blank (as I don't have data yet) I would like to add in formatting for the highlighted cells to also remain blank.
I understand it is incredibly hard to communicate this error over text but any help will be greatfully appreciated.
Many thanks,
GPepperell
6 Replies
- SergeiBaklanDiamond Contributor
- GaryPepperellCopper Contributor
Thanks for you so much! That works great. I knew I was missing just a little something.
Much appreciated and kind regards,
GPepperell
- SergeiBaklanDiamond Contributor
GaryPepperell , you are welcome, glad to help
- peteryac60Iron Contributor
Gary
You are right - it is difficult to communicate.
If you can attach the document we can look and see!
thanks!
Peter
- GaryPepperellCopper Contributor
- GaryPepperellCopper Contributor@peteryac6- all sorted now, thank you for looking into this for me though!