Conditional formatting assistance

  • Thread starter Thread starter Mark Elliot
  • Start date Start date
M

Mark Elliot

Hey all,
I was hoping one of you could point me in the right direction... I
have a single sheet Excel document to which I want to apply some
conditional formatting. Rows 1 and 2 are header information (date).
Column 1 and 2 also display information that doesn't contain data
(city).

The sheet contains a list of broken items that I've fixed. When I've
fixed the same thing twice, I want the cells containing that item to
turn color. When it's entered a third time, turn a different color,
and a fourth time, a final color.

For example, I enter Chicago_washer_1 in cell C3. Three months
later, I enter Chicago_washer_1 in cell X7. I want C3 and X7 to turn
red. If I then enter Chicago_washer_1 in cell AB5, I want all three
cells to turn blue.

Thanks so much for the advice.



Regards.
 
Maybe tinker around these lines ..

While holding down CTRL,
click to select the 3 cells C3, X7 and AB5

Click Format > Conditional Formatting

Make the settings

For Condition1:

Formula Is|
=SUM(COUNTIF($C$3,"x"),COUNTIF($X$7,"x"),COUNTIF($AB$5,"x"))=2

Click Format button > Patterns tab > Red? > OK

Click Add>> button

For Condition2:

Formula Is|
=AND($C$3="x",$X$7="x",$AB$5="x")

Click Format button > Patterns tab > Blue? > OK

Click OK at the main dialog
 
I think this will get you started:

Open the Conditional Formatting box with your active cell being in th
top left corner of the range of cells containing your data.

Choose "Formula Is" in the drop down list and then type in the formul
area this formula:
=countif($a$5:$ab$50,a5)=4
this assumes your range of data to be A5:AB50 - change to suit
Set the format you want

Use the same formula for Condition 2 (by clicking the Add button) bu
change the last digit to 3 and set that format

Same for Condition 3

Make sure you set your conditions from 4 as Condition 1 down to 2 a
Condition 3 (not the other way around) and make sure you use the dolla
signs in the formulas correctly.

Now copy the formatting to each cell in the range
 
Cutter-- worked like a charm. Excatly what I wanted to do.
Thanks so much for your help. Off to fix the washers in Chicago.
 
Back
Top