Just wondering if anyone has used conditional formatting to blank a cell where the immediately above cell has the same value. I am using xlsxwriter to produce the spreadsheet
e.g.
1
1
2
2
3
4
should appear
1
2
3
4
Just wondering if anyone has used conditional formatting to blank a cell where the immediately above cell has the same value. I am using xlsxwriter to produce the spreadsheet
e.g.
1
1
2
2
3
4
should appear
1
2
3
4
You can have CF assign a font color equal to the fill color if the cell's value is equal to the previous cell's value.
Use the CF-option where you can enter a formula.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Would that solution work for a printed sheet ? Some customers are doing that
I guess so. Unless it's printed on coloured paper.
Just try it and you'll know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks