Answered By: Reference Librarians
Last Updated: Oct 18, 2016     Views: 2447

Hello,

If you select your data, the quick analysis button should appear at the bottom right corner of the screen.  It can also be accessed by typing Ctrl + Q.  

This Excel guide for Excel 2013 and 2016 details the process: https://support.office.com/en-ie/article/Apply-conditional-formatting-by-using-Quick-Analysis-24c27f89-f84a-4e1d-b1ae-f631e3a7a2e6?ui=en-US&rs=en-IE&ad=IE  

Contact Us!

Main Library: (330) 490-7185

Questions? Ask Us!

Related Topics