Jun 20 2020 08:30 AM
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
Jun 20 2020 08:41 AM
Gary
You are right - it is difficult to communicate.
If you can attach the document we can look and see!
thanks!
Peter
Jun 20 2020 08:50 AM
SolutionJun 20 2020 10:36 AM
Jun 20 2020 10:40 AM
Thanks for you so much! That works great. I knew I was missing just a little something.
Much appreciated and kind regards,
GPepperell
Jun 20 2020 10:41 AM
Jun 20 2020 12:01 PM
@GaryPepperell , you are welcome, glad to help
Jun 20 2020 08:50 AM
Solution