## Hot answers tagged conditional-formatting

2

Rather than using Specific Text, try using Cell Value and equal to, then enter C for one rule and O for the other (do not enter equal or quotes when entering the letter, Excel does it for you). This will look for the only the letters that match.
Applied to the whole column, this ignores text of the Open / Closed heading.

1

If I understand what you are asking, you can accomplish this with two conditional format rules which use formulas. You didn't state what version you are using, so you will have to use whatever method you need.
The first rule will use the following formula: =AND(NOT(ISBLANK($L1)), $A1="Flag set") This checks to see that L is NOT blank AND A1="Flag set". If ...

1

Select cell A1 (if you don't, these directions will not work due to the relative reference you create in step #3...which is the key to being able to apply these conditions to all the entire worksheet)
Create a new Conditional Formatting rule of the Use a formula to determine which cells to format type
In the Format values where this formula is true: text ...

1

You can use a conditional format to highlight every other set of unique values.
=MOD(SUM(--(OFFSET($A$1,0,0,MAX(ROW(A1)-1,0))<>OFFSET($A$2,0,0,MAX(ROW(A1)-1,0)))),2)
You can significantly shorten the formula if you have a maximum range you want to apply the formatting over, but it would be less robust.
=MOD(SUM(--$A$5:$A5<>$A$6:$A6),2)

1

Use the following formula in the conditional formatting. I assumed row 1 is the header row.
=MOD(ROW(),10)-1=1

1

Select the cells in column A. Create a new conditional format based on a formula (Click Conditional Formattting > New Rule > Use a formula to determine which cells to format).
Use this formula
=COUNTIF($B:$B,A1)
Click the Format button and select a format for example a fill color. Click OK.

Only top voted, non community-wiki answers of a minimum length are eligible