Excel in Excel®!. Issue 2 (1st February 2017)

• Record Type: Journal Article
• Authors: Ayer, Ganesh
• Is Part Of: Energy engineering. Volume 114:Issue 2(2017)
• Page Start: 56
• Page End: 65
• Publication Date: 2017-02-01
• Subjects: Power (Mechanics) -- Periodicals; 621.04205
• DOI: 10.1080/01998595.2017.11833485
• Languages: English
• ISSNs: 0199-8595

Abstract

ABSTRACT: Conditional formatting aids data visualization* . Among the numerous details in a spreadsheet, you may want to flag, mark, or highlight specific or key values like high value, low value, duplicate values, top 20 values, etc. You want these values to standout for some reason. You want to do this without sorting the data or using macros. Conditional formatting allows you to do just that, and you can even setup particular rules yourself. Conditional formatting can be implemented in multiple ways, and in this article, we will examine a few of them.