Have a big sheet where many cells (spread around) have green background color. Is there a easy way to change background color only for this cells from green to red?
The green cells don't have anything in common except beeing green so I can't use conditional formating. Don't know if there is a fast and easy solution, but appreciate any tips or hint.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…