LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Hyland Hunt
 
Posts: n/a
Default Conditional formatting row if cell value in certain column is even

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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting for row given conditino in cell Dave Breitenbach Excel Worksheet Functions 4 February 1st 05 02:27 PM
conditional formatting conflict? Abi Excel Worksheet Functions 2 January 11th 05 03:41 PM
conditional formatting blank cell TREK5200 Excel Discussion (Misc queries) 1 December 6th 04 02:23 AM
copying conditional formatting to an entire column MaryMalone Excel Discussion (Misc queries) 1 November 30th 04 04:04 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"