Today I have a question about conditional formatting and whether to achieve what I need I would have to create many additional calculated fields.
I have a table with days as columns and hours as rows.. The text is number of visits.
I would like to apply formatting (colour) to the best day within a column, and within a row (two different colours). How do I do that?
Do I have to create calculated field of Max and compute it twice - one max for a day, and one max for an hour ?
You can find a great workbook out here:
....That Jonathan Drummey created to show you all sorts of things you can do with formatting. The scenaroi you're asking about is towards the end of the workbook (it's big!) as I recall.