Search code examples
excelexcel-formulaexcel-2010worksheet-functionconditional-formatting

Multi-function conditional formatting cell range

I want to give a quick indication using coloured cells of the time likely to be taken to complete a task. So for example:

if cell B2 = 1 then fill cell range G2:H2 with light red
if cell B2 = 2 then fill cell range G2:J2 with light red
if cell B2 = 3 then fill cell range G2:L2 with light red

How might I achieve this?

Solution

  • Select G2:H2 and use a CF formula rule of: 

    =$B$2=1

    Select G2:J2 and use a CF formula rule of: 

    =$B$2=2

    Select G2:L2 and use a CF formula rule of: 

    =$B$2=3

    each with the formatting of your choice.