Cell Format With VBA

[Garysmith]

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.

[sweep]

Hi,

In the worksheet module (ie; right click on the tab name and select "view code") enter the following:

Please Login or Register  to view this content.

[Garysmith]

Many Thanks Sweep. Perfect.
I knew it could be simple, I was just too simple to see it.