Conditional formatting to highlight the cells?
Take the pain of exporting the data, then do it a sensible way?
Quote from: ElyDave on 02 March, 2022, 06:27:00 amConditional formatting to highlight the cells?There are over 100 sheets in this ODS workbook.<deity> onna bike, I really wish they'd put this data into something sensible, like YAML or JSON. Then I could just grep it.
Quote from: Jaded on 02 March, 2022, 09:38:21 amTake the pain of exporting the data, then do it a sensible way?XKCD has the answer.https://xkcd.com/2180/
Which edition of Excel? In sufficiently recent Excel (2021 or 365) it can be done in a single formula, or at least a single formula per page.
Quote from: HTFB on 09 March, 2022, 02:04:46 pmWhich edition of Excel? In sufficiently recent Excel (2021 or 365) it can be done in a single formula, or at least a single formula per page.365I really need to be able to search the entire workbook. There are over one hundred sheets.