{"id":2300,"date":"2026-10-01T10:49:00","date_gmt":"2026-10-01T10:49:00","guid":{"rendered":"https:\/\/www.exceldepartment.com\/?page_id=2300"},"modified":"2026-10-31T12:13:32","modified_gmt":"2026-10-31T12:13:32","slug":"create-conditional-formatting","status":"publish","type":"page","link":"https:\/\/www.exceldepartment.com\/en\/excel-course\/excel-basic-course\/conditional-formatting\/create-conditional-formatting\/","title":{"rendered":"Create conditional formatting"},"content":{"rendered":"
\n

Create conditional formatting<\/h1>\n

To create conditional formatting, do as follows:<\/p>\n

    \n
  1. Select the range of cells you want to format.
    (Some conditional formatting, such as colour scales, also depends on the content of other cells controlled by the same conditional formatting. Keep that in mind when you select the range of cells!<\/li>\n
  2. Click Conditional Formatting under the Home tab and choose the formatting you want. See examples below.\n

    \"Basic\"Basic\"Basic<\/p>\n

    \"Basic\"Basic<\/p>\n<\/li>\n<\/ol>\n

    \n
    \n
    <\/p>\n
    \n
    \n

    Previous<\/h2>\n

    Conditional formatting<\/a><\/p>\n

    <\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
    \n

    Index<\/h2>\n

    Excel Basic Course Online<\/a><\/p>\n

    <\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
    \n

    Next<\/h2>\n

    Remove conditional formatting<\/a><\/p>\n

    <\/div>\n<\/p><\/div>\n<\/p><\/div>\n

    <\/center><\/div>\n<\/div>\n

    Some of our clients<\/h2>\n

    We have both large and small companies as clients.<\/p>\n

    \n
    \n
    \n
    \n\t\t\t\t\t\t
    \"Continental\"<\/a><\/div><\/div><\/div>
    \"Kalmar<\/a><\/div><\/div><\/div>
    \"Lundstams\"<\/a><\/div><\/div><\/div>
    \"Fria<\/a><\/div><\/div><\/div>
    \"Newsec\"<\/a><\/div><\/div><\/div>
    \"EMC\"<\/a><\/div><\/div><\/div>
    \"Fortum\"<\/a><\/div><\/div><\/div>
    \"Navetti\"<\/a><\/div><\/div><\/div>
    \"Traffic<\/a><\/div><\/div><\/div>
    \"Viafone\"<\/a><\/div><\/div><\/div>
    \"Visma\"<\/a><\/div><\/div><\/div>
    \"Hush\u00e5llningss\u00e4llskapet\"<\/a><\/div><\/div><\/div><\/div>
    <\/i><\/div>
    <\/i><\/div><\/div><\/div><\/p>\n
    <\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
    \n