New answers tagged conditional-formatting
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.
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.
Here are the rules. If you'd like them for the entire sheet then simply extend the range (Applies to)... =IF($G1="Cats",TRUE,FALSE) =ISTEXT(B1) =NOT(ISBLANK($A1)) Please note that the order is important
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)
I have a solution that does not exactly do what you want, but based on your description, I think it serves your purpose. Follow these steps: Select the cell second data item that you want to color. Select "Conditional formatting", "Highlight cell rules", "Equal to..." Select the first data item you want to color and remove the $'s from the cell reference ...
Use the following formula in the conditional formatting. I assumed row 1 is the header row. =MOD(ROW(),10)-1=1
Top 50 recent answers are included