Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How can I set conditional formatting for a row when the value in the first
cell of the row contains data? I have tried the following formulas, and neither does anything, even when it's the only conditional formatting. =($A1<"") =(A1<"") Thanks to your help to other people on formatting every other row, I am able to format rows 4,8,12, ... one color, and rows 2,6,10 another color. By playing around, I found that the formatting occurs when the value is TRUE or 1, so I don't understand why one of the above formulas doesn't work. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |