conditional formatting varios named cells

Unfortunately , in using the word "Conditional", Microsoft chose to use a word that has a much wider in meaning to us than it does to Excel - that was not very helpful.

In the attached workbook I have created a new style called "Kev" (with borders and fill), as illustrated below.

Format any cells quickly by clicking on each cell in turn and then click on style "Kev"
If you hold the {CTRL} key down after selecting the first cell you can select more cells and format them all together with one click.

The fact that the cells are named is of no consequence to this solution

The next post will include a VBA solution which can use the named ranges

CellNewStyle1.jpg

CellNewStyle2.jpg

CellNewStyle3.jpg