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.
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.