Browse:
Was this helpful? Yes 0 No 8
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