Conditinal Formatting

  • Thread starter Thread starter PA
  • Start date Start date
P

PA

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
 
select/ highlight the whole area from A2 to H1245
go to format ...conditional formatting....condition1
select "formula Is" in the dropdown and enter =$H2="R"
format..............select red colour in pattern
select add
repeat formula is............. enter =$H2="G" format..... etc
select add
repeat formula is............. enter =$H2="B" etc
 
Back
Top