Conditional Formatting Based on Formula & Cell Value?

Question

I have a spreadsheet with point values in the odd rows.  I would like to highlight (bold red or something like that) any zeros that are in the odd rows of my spreadsheet.

I know how to format the ever odd row in its entirety and I know how to Conditionally Format a cell that contains a zero.

Is there a way to conditionally format cells in odd rows that contain a zero?

Thanks,

J

Answer 1

Can you share the screen-shot of the CF formula that you used for cell C1.

I have a feeling that you would have not removed the $ in that formula and hence

when you apply that CF to other range, it does not work.

Answer 2

Thanks for your suggestion.  

I formatted C1 with the rule you suggest (it makes sense to me).

However, when I apply it to a range of cells, none of them turn red (the value of C1 was not 0).

It seems like the formula is checking the value of C1 and not the current cell.

Answer 3

Pls try      =AND(C1=0,ISODD(ROW()))      as a formula for Conditional Formatting.

The above formula is applied in column-C (pls see pic below).

Hope this is Helpful.