Hi all,
I need to change the color of a group of blank cells based on the value of another cell, for example if A1 contains "E" A3 to A5 will have a fill color of orange.
I have done a fair amount of searching and I have found the INDIRECT command which I can use to turn the entire row orange but this won't work for me.
Thanks
Bookmarks