Forum Discussion
Mikaelleo
Aug 04, 2020Copper Contributor
Looking for a formula
Hello there, I would need help to know which formula I should use or which one would be the best to satisfy my need. This is an extract of some returns that I need to refund. Column H is fi...
NikolinoDE
Aug 04, 2020Platinum Contributor
It is also possible to do this with conditional formatting.
Use conditional formatting to highlight information
https://support.microsoft.com/en-gb/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f?ui=en-us&rs=en-gb&ad=gb
If you liked one of the suggested solutions, please click on it as the correct answer, if possible with a like (thumbs up). If neither is the solution you are looking for, please give us a quick feedback.
Best regards,
Nikolino
I know I don't know anything (Socrates)
Use conditional formatting to highlight information
https://support.microsoft.com/en-gb/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f?ui=en-us&rs=en-gb&ad=gb
If you liked one of the suggested solutions, please click on it as the correct answer, if possible with a like (thumbs up). If neither is the solution you are looking for, please give us a quick feedback.
Best regards,
Nikolino
I know I don't know anything (Socrates)