A Kinder, Gentler Report

I really hate a report (whether Excel, HTML, or Word) that uses full-strength colors as visual aids. They’re too jarring!

passed
missed
failed

Instead, I’m now using the colors I cribbed from MS Excel’s Home tab, in Styles.

passed
missed
failed

[Here in WordPress I did not find out how to make narrow cells. Sorry.]

The new colors will look more true (and better) if you scroll down so that the old colors are no longer on your screen.

Excel

My History Report is an Excel spreadsheet. For that report, I’ve set the whole spreadsheet to conditional formatting. Here’s how:

  1. Select entire worksheet (by pressing Ctrl-A).
  2. Passed:
    1. Go to Home => Conditional Formatting => Highlight Cell Rules => Equal To....
    2. Type passed.
    3. Select Green Fill with Dark Green Text.
    4. Click button OK.
  3. Missed:
    1. Go to Home => Conditional Formatting => Highlight Cell Rules => Equal To....
    2. Type missed.
    3. Select Yellow Fill with Dark Yellow Text.
    4. Click button OK.
  4. Failed:
    1. Go to Home => Conditional Formatting => Highlight Cell Rules => Equal To....
    2. Type failed.
    3. Select Red Fill with Dark Red Text.
    4. Click button OK.

Then, any cell that has text passed, missed, or failed is automatically formatted appropriately.

HTML

My Changes Report is an HTML page. For that report, I’ve used the MS Excel colors as above, by adding this to the style section in the head section:

.good {color: rgb(0,97,0) ; background-color: rgb(198,239,206) }
.neutral { color: rgb(156,101,0) ; background-color: rgb(255,236,156) }
.bad { color: rgb(156,0,6); background-color: rgb(255,199,206) }

Then a cell can be, for example, defined in the HTML as:

<td class="good">passed</td>

The cell is then rendered with that same font color and background color as is seen in the Excel spreadsheet above.

MS Word

For a Word document, …

Well, actually I don’t generate reports in Word documents.

Advertisements

2 thoughts on “A Kinder, Gentler Report

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s