| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Much easier - thanks!
"Gord Dibben" wrote: Select the entire row or a range of cells across that row, say A1:L1 FormatCFFormula is: =$A$1=0 The row or range of cells will turn color if A1 is = to 0 Note the $ signs which fix A1 as the trigger cell. If doing a bunch of rows at the same time, say A1:L50 the formula would read =$A1=0 which fixes the column but not the row. Gord Dibben MS Excel MVP On Wed, 21 Mar 2007 11:28:03 -0700, jostlund wrote: How would I apply conditional formatting to a row if cell = 0, and not just to the cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting | New Users to Excel | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
