Hello
I have a sheet with a named range, "tasks"
I'm struggling with some code that if cells in the named range are changed, those cells are formatted with the following.
Cells with an "R" fill red
Cells with a "B" fill blue
All others have no fill.
This would apply to the active sheet only.
Thanks in advance. Any help would be gratefully received.
Bookmarks