Conditional formatting entire workbook
Solved
jejedeadpool
-
Robbynator -
Robbynator -
Hello,
I have a little issue with conditional formatting... In Excel 2003, we could apply it to an entire workbook...
So in my workbook, I have 56 tabs, and in those tabs, there are tables with 1 to 50 per tab :$
In these tables, I have a cell titled either "NIV 1" or "NIV 2" or "NIV 3", and I would like for level 1 to have a green background, level 2 orange, and level 3 red...
Hence the conditional formatting, and I really don't have the time to make one for each tab...
Does anyone have any ideas?? Thanks in advance
Configuration: Windows 7 / Firefox 7.0.1
I have a little issue with conditional formatting... In Excel 2003, we could apply it to an entire workbook...
So in my workbook, I have 56 tabs, and in those tabs, there are tables with 1 to 50 per tab :$
In these tables, I have a cell titled either "NIV 1" or "NIV 2" or "NIV 3", and I would like for level 1 to have a green background, level 2 orange, and level 3 red...
Hence the conditional formatting, and I really don't have the time to make one for each tab...
Does anyone have any ideas?? Thanks in advance
Configuration: Windows 7 / Firefox 7.0.1
4 réponses
Hello everyone.
There is indeed a quick solution, but it's only interesting if your formats (formatting) are identical across all sheets:
1) select a cell that has your 3 conditional formats
2) click on the "Format Painter" icon (yellow brush in Home)
3) select all sheets: click on the first tab; hold down the Shift key; click on the last tab
4) click on the cell at the top left (above row number 1, and to the left of column marker A)
* that’s it! ... before you continue working, don’t forget to deselect the group of sheets by clicking on one of the intermediate tabs.
Best regards.
--
Retirement is great! Especially in the West Indies... :-)
☻ Raymond ♂
There is indeed a quick solution, but it's only interesting if your formats (formatting) are identical across all sheets:
1) select a cell that has your 3 conditional formats
2) click on the "Format Painter" icon (yellow brush in Home)
3) select all sheets: click on the first tab; hold down the Shift key; click on the last tab
4) click on the cell at the top left (above row number 1, and to the left of column marker A)
* that’s it! ... before you continue working, don’t forget to deselect the group of sheets by clicking on one of the intermediate tabs.
Best regards.
--
Retirement is great! Especially in the West Indies... :-)
☻ Raymond ♂
in Excel 2013 it works perfectly