Excel 2007: Change background color cells ->not based on value of cell

Question

Is possible to change background without based on value of cell?

So for example, all blue cells on Sheet change to red.

Conditional formatting does not allow this.

Thank you.

Answer 1

You can do this via Find/Replace. Just leave the text values for Find what and Replace with empty and rather select a format.

Image of settings