Hello everyone,
I struggled with conditional formatting and formulas with this but I cannot do it right. I need the first and last row that contain values different to 0 to have a specific formatting.
If the first row is 0, jump to the next row until ≠ 0 and format as €* #.##0,00_);€* (#.##0,00);€* —;@ and all the rows before it, which = 0, should be formatted as #.##0,00_);(#.##0,00);—;@ or left at default.
The dollar / euro sign must appear only on the first and last numerical value.
I have attached an example file, because I do not know how to explain this any better: https://www.mediafire.com/?geziib714orytlb
I hope someone has the answer, thanks.
I struggled with conditional formatting and formulas with this but I cannot do it right. I need the first and last row that contain values different to 0 to have a specific formatting.
If the first row is 0, jump to the next row until ≠ 0 and format as €* #.##0,00_);€* (#.##0,00);€* —;@ and all the rows before it, which = 0, should be formatted as #.##0,00_);(#.##0,00);—;@ or left at default.
The dollar / euro sign must appear only on the first and last numerical value.
I have attached an example file, because I do not know how to explain this any better: https://www.mediafire.com/?geziib714orytlb
I hope someone has the answer, thanks.
