Alternating shading of lines
Alternating shading of lines
In Excel you can have different shades on alternate lines to make it easier to scan. Is that possible in PlanMaker?
Re: Alternating shading of lines
It seems, you are referring here to tables. We have tables in PlanMaker also with multiple designs.
You can use tables by following these steps:
1. Select range.
2. Click on ribbon command Insert | Table dropdown | Select the desired table design.
3. Click insert on table dialog box.
You can use tables by following these steps:
1. Select range.
2. Click on ribbon command Insert | Table dropdown | Select the desired table design.
3. Click insert on table dialog box.
Re: Alternating shading of lines
Thanks for your post. Your method worked for a limited range of cells, but when one of the dimensions was unlimited, the process took forever. For example, I selected 10 rows with unlimited columns. This resulted in a hourglass cursor that continued for 10 minutes before I decided to kill the program.
What I found does work for the entire spreadsheet is to select all cells, then Home->Conditional Formatting->New Rule. For Type choose Use a formula to determine which cells to fomat.
In Format, enter MOD(ROW(),2)=0
Select the Format button in Preview.
Select Shading.
in the Foreground dropdown, select the colour for the even row.
In the Background dropdown, select the colour for the odd row.
You can define your own colours. To see the result.
Select OK OK. The result is immediate.
What I found does work for the entire spreadsheet is to select all cells, then Home->Conditional Formatting->New Rule. For Type choose Use a formula to determine which cells to fomat.
In Format, enter MOD(ROW(),2)=0
Select the Format button in Preview.
Select Shading.
in the Foreground dropdown, select the colour for the even row.
In the Background dropdown, select the colour for the odd row.
You can define your own colours. To see the result.
Select OK OK. The result is immediate.