Conditional formating

donnylad said:

Yes dead right I'm happy now. Thanks very much.
Len

Len, glad you got it working the way you wanted.
Bob

@donnylad @Lottiemansion
I went back and took a second look at why I couldn't get my original formula to work with the data in rows. What I discovered is that I made a simple mistake in using mixed cell references compounded by incorrectly formatting one of the search criteria. It now work correctly.

In case you would like to see a good tutorial for using mixed cell references here is the link: Excel cell references - relative absolute references in conditional formatting rules
Sorry this took so long to solve. It appears that my Excels skills have eroded a bit in retirement.
Bob

donnylad said:

I'm sorry Bob but when I input that and then added "Applies to" across the whole row nothing happened on any, and don't forget sometimes some of the cells are blank. I don't think that this will take into account that situation.
Len

@donnylad
Select the entire range of row/columns first then click on conditional formatting, create new rule, and then enter the formula adjusted for the relative locations of the first pair on rows. It should work. I tested it with empty cells.

Let me know it you cannot get it to work.
Bob

donnylad said:

Sorry my mistake, it does work. thanks Bob.
Len

Great news.