Excel 2003
I have a data list using A1 through H1245. Row 1 contains the field
headers, with column H called Code. The values in column H are selected from
a drop-down list (validation), with the values set for R, G, or B.
I need to step up Conditional Formatting, such that when an R is selected in
a cell in H, the row, columns A thru H turns Red, G will turn a row Green,
and B will turn a row Blue. We cam then sort by Code to group the colors.
The colors do have some significance to a senior manager.
Suggestions on how to accomplish this will be appreciated.
Thanks
Paul