New
#21
Yes dead right I'm happy now. Thanks very much.
Len
Yes dead right I'm happy now. Thanks very much.
Len
@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
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
Sorry my mistake, it does work. thanks Bob.
Len