In microsoft excel, I know how to do a standard if statement with characters and numbers, but I'm having a problem. Is it possible to use an if statement to change background color. Specifically, I have a huge spreadsheet with certain cells that are black. I need to change these cells to have an 'X' in them, so I was hoping there was some kind of if statement like this:

if (background ="black", "x", "")

I just don't know if there's a certain way to write that.

Only Conditional Formatting or VBA will allow you to change cell colors.

Conditional formatting cannot change the cell's contents, however. So you're left with VBA. Is this a one-time change, or do you need to automatically create an 'X' when the cell's background is changed?

Basically it's a large spreadsheet. Some cells are normal (no color fill) and some are filled black. I'm looking for a shortcut formula that will put an 'X' in cells that are black, because going through one by one will take a while. If i have to do that I will, but a formula that can conditionally check the cells would make my life easier.

Try the attached.

It was close enough. I know enough VB to edit the macro to how I need it. I just wasn't 100% sure on the syntax. It works great now. Thank you very much for your help.