conditional formatting using IF with MID functions

[jdubwelch]

okay, I have a sheet with a bunch of skus, ie "MCREADER". If i have none in stock, I want it to be red. I will indicate that I have none in stock by putting a zero as the first character. So the sku would then be "0 MCREADER".

Now, I select that cell "C11" in this case. Go up to conditional formatting. And use the formula:

Code:

="IF(MID(C11, 1, 1) = 0)"

Select the background to be red.

But nothing happens. Is there something wrong with my formula.

Also, how would apply this to all the cells on the sheet. How do i copy & paste the conditional formatting to apply for all the cells, that i set up for that one cell.

If there's a better way to do this, please let me know.
thanks for any help in advance.

[VBA Noob]

Maybe

=MID(C11, 1, 1) = "0"

VBA Noob

[jdubwelch]

so that worked, but how do I copy & paste that conditional format to all the cells?

so A1 would have A1 in the formula, B2 would have B2, etc.

[VBA Noob]

=MID(A1, 1, 1) = "0"

#

VBA Noob

[jdubwelch]

I tried this and it gave me an error in the formula.

=IF(MID(#, 1, 1) = "0", TRUE)

So basically, I need the symbol for the cell value to instert where I have the "#"

[Bjornar]

You can copy and paste conditional formating by using "paste special" and select "Formats" from the paste special menu.