Conditional Formatting

[ysbn]

I want the following condition assigned to the formatting of cell A1:
If the value of cell B1 is identical to the value of C1, D1, E1, F1 or G1 then A1 pattern if colored red.
The problem is that Excel lets me define only 3 different formatting conditions per cell so I'll need to use a different formule then '=B1=C1'.

thanks in advance!

[NBVC]

use OR() in your CF formula.

select formula is from 1st drop down. Then enter formula

=OR(B1=C1,B1=D1,B1=E1,B1=F1,B1=G1)

[ysbn]

thanks, can I also clear the cell content when the above condition is met?

[NBVC]

You can't clear the contents, but you can make the contents transparent by changing the font colour to match your background colour when your conditions are met.

[ysbn]

.. not with the "conditional formatting" tool?

I have aggregations based on this cell. I need it to clear, not just change color.

[NBVC]

use the conditional formatting tool to change the font colour. You can't clear/delete the contents with the CF tool.