Conditional Formatting

[Frank Harrison]

I am looking to use conditional formatting to highlight a cell when a one in five rows condition is exceeded.

Order Key	VS-455
A04532	X
A01323
A01022
A01331
A06877	X Thid cell should highligrt red because there is an "X" Four rows above
A01003
A01922
A02403
A02740
A04565	X
A01394
A01246
A07754
A01271
A09886	X

 

[Joe4]

You should be able to use a COUNTIF to count how many "X"s there are in the 4 rows above, and if it is more than 0, i.e. the Conditional Formatting formula would start in B6 and look like:

=COUNTIF(B2:B5,"X")>0

 

[Frank Harrison]

Every time an "X" occurs I need it to evaluate the four cell above and below to make sure no othes rows contain an "X"

 

[Joe4]

OK, looks you conditions changed, as you now want to check above AN D below, instead of just below.

What row/column does your data actually start in?

 

[Frank Harrison]

Sample file attached I think the rows above would nohave to be considered because they would be covered.

 

[Joe4]

What row/column does your data actually start in?

You did not answer my question, and your image does not show row or column headers, so I cannot see what ranges you are working with.