How to make color conditional style consistent for HTML, PDF and EXCEL

Check list of all posts

This is a practical sample to make color conditional style beautiful with round.  Excel spreadsheet doesn’t support such a round color. This article provides a way to make all three format be consistent


HTML format

PDF format

 EXCEL format

Make color conditional style beautiful with round for both HTML and PDF, while this definition won’t show color for excel

Add new block to list cell, and specify an appropriate size

Define conditional style
 


Use advanced style with round

Use advanced style with color

Make color conditional style for EXCEL, while this definition won’t show color for HTML and PDF.