Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The only way I know to do it is by placing a conditional format within each
cell, unless you had a macro do it automatically. I might could help you better if I knew exactly what you wanted to accomplish. However, based on your example, I am going to use A1 as the cell that equals 0 and row 1 as the row you wish to apply the condition to. Not knowing how far down the row you need the condition, I will say from A1:M1. In each cell (A1:M1) place the below formula: =AND($A$1<"",$A$1=0) Make sure you indicate "Formula Is" in condtion. Les "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 | |
|
|
![]() |
||||
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 |