Hello,
I'm using Excel 2007 and want to know if something possible through the user
interface. I'd like to change the background color of columns A through H in
each Row based on the value of that row's column B.
All column B values are restricted via Data validation. The five
permissible values a Blue, Green, Yellow and Red and blank.
I expect that I'd use Conditional Formatting, but I can't seem to find out
how to use that functionality to change the background color of each row's
A-H range based on the text value in column B.
I can use a Macro / VB solution if I have to, but I want to exhaust the user
interface first. Many thanks for all your help.
--
Programmer on Budget