Highlighting a cell if range of cells have the same value

[frenkiy]

Hello all. So i need a formula to highlight cell "TEST1" if all cells in third row are "+", if any of them is "-" cell "TEST1" is not highlighted.
Thanks for help.

[sweep]

Hi,

Using conditional formatting, use this formula to activate the cell format:

Please Login or Register  to view this content.

[frenkiy]

Hi,

Using conditional formatting, use this formula to activate the cell format:

Please Login or Register  to view this content.

Thank you so much. I have implemented that formula in conditional formating and works like a charm

[davesexcel]

CF is based on true or false.

If the count of "+" in column B=the count of column A then it is true.

Please Login or Register  to view this content.

[frenkiy]

CF is based on true or false.

If the count of "+" in column B=the count of column A then it is true.

Please Login or Register  to view this content.

Also works nicely. Thank you!