Conditional formatting row if cell value in certain column is even

G

Guest

I'm fairly new to conditional formulas... I have a spreadsheet where one
column has a list of numbers, when cell values in that column are even, I'd
like to shade the entire row.

I've managed to get the cell with the number shaded by just selecting the
column with those numbers and using =MOD($A1,2)=0
(The numbers that I'm checking for odd/even are in column A. The rest of
the spreadsheet is text or dates).
However, if I select the entire worksheet and enter that same formula, the
entire worksheet gets shaded, which I don't understand.

How do I shade the entire row when a conditional format finds a cell that
meets what I've specified?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting row when cell value is an even number 5
Comparison of columns using Conditional Formatting 3
Shading Rows With IF Statements? 5
Conditional Formatting if cell is Blank 2
How to shade a row of cells using conditional formatting 4
Conditional Formatting Multiple Columns 2
Use of CELL("protect") in conditional formatting in Excel 07 3
Conditional formatting a cell containing "<" 4

Top