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?
|