Conditional Formatting of Cells with Multiple Conditions in Excel - Office 365

preview_player
Показать описание
Often you may want to apply conditional formatting to cells or rows based on multiple conditions in Excel. You can apply conditional formatting based on multiple conditions in one column or different columns. This video explains in detail the different ways you can apply conditional formatting to cells based on multiple conditions.

To download practice Excel file please click on the link below

To learn more about conditional formatting of cells in Excel please click on the link below
Рекомендации по теме
Комментарии
Автор

What if I wanted to highlight sales rep name from sale? So sale contains value less than $1000 formats sales rep name in a color?

MrByrd
Автор

There is no conditional formatting on Microsoft 365. I’m using a phone

petra-rock