Back to How to use Custom and Conditional Formatting in Excel
Coursera

How to use Custom and Conditional Formatting in Excel

By the end of this project, you will learn how to use conditional and custom formatting in an Excel Spreadsheet by using a free version of Microsoft Office Excel. Excel is a spreadsheet that is similar in layout as accounting spreadsheets. It consists of individual cells that can be used to build functions, formulas, tables, and graphs that easily organize and analyze large amounts of information and data. Conditional formatting is a convenient tool for data analysis and visual representation of results. Knowing how to use this tool will save you a lot of time and effort. A fleet glance at the document will be enough to obtain the necessary information.

Status: Computer Literacy
Status: Spreadsheet Software
IntermediateGuided Project1 hour

Featured reviews

TG

Reviewed Oct 15, 2025

It has been explained in so simple manner that any one can try along with this video.

MM

Reviewed Oct 8, 2022

G​reat in a word. I'm impressed by the course module..

VT

Reviewed May 30, 2023

Thank you Coursera for wonderful learning opportunity.

SS

Reviewed Jan 12, 2023

Teacher explains everything in detail. She allotted time to stop the video to fill in my spreadsheet. TY

All reviews

Showing: 19 of 19

Desiree
Reviewed Jun 3, 2024
SA
Reviewed Jan 12, 2023
Danielle
Reviewed Jun 7, 2024
Ashim
Reviewed Aug 10, 2023
Rais
Reviewed Jun 3, 2024
Lauren
Reviewed Jun 24, 2023
Trushar
Reviewed Oct 16, 2025
Vikram
Reviewed May 31, 2023
Md.
Reviewed Oct 9, 2022
Cindy
Reviewed Jan 6, 2023
Adam
Reviewed Nov 5, 2025
STEVENSON
Reviewed Jun 17, 2023
Libero
Reviewed Aug 31, 2025
Umar
Reviewed Dec 15, 2025
Raj
Reviewed Dec 6, 2022
DIONISIO
Reviewed Jul 25, 2024
redouane
Reviewed Jul 1, 2023
Kevin
Reviewed Mar 14, 2025
Adit
Reviewed Dec 23, 2025