Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting for row given conditino in cell | Excel Worksheet Functions | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
conditional formatting blank cell | Excel Discussion (Misc queries) | |||
copying conditional formatting to an entire column | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |