Conditional Formatting in Excel 2007

  • Thread starter Thread starter LabLawrence
  • Start date Start date
L

LabLawrence

Hi all-
Can someone give me detailed directions on how to format a column so that
the cells with 4's in them are highlighted yellow, the cells with 5's in them
are red and the cells with 6's are blue. I have tried using the wizard but
the numbers 1-3 get highlighted also. Thanks in advance.
LabLawrence
 
Select the cells
Open the Conditional Format dialog, use Highlight Rules -> Equal To;
in the left had box enter 4, in the right-hand select a colour combination
as needed
Repeat for 5.
best wishes
 
In EXCEL 2007:-

1. Highlight the range of cells to which you wish Cond Form to apply (eg M1
to M71).

2. Home / Conditional Formatting / New Rule

New Formatting Rule pane should launch.

3. Select:-

Only cells that contain

4. Change:-

between

- to:-

equal to

- and put a 4 in the box to the right.

5. Hit Format so that the Format Cells pane launches.

6. Change the;-

Color:

- field to yellow and hit OK and OK again.

7. Repeat steps 2 to 6 above inclusive but changing the number 4 to 5 and 6
and the colours to red and blue respectively.

You should now have 3 rules set up for the range specified at number 1 above
(M1 to M71).

8. Test the rules by entering data in the range M1 to M71 and making sure
that the right colours are returned.

I have tested the above and looks OK to me.

If my comments have helped please hit Yes.

Thanks.
 
Back
Top