Forum Discussion

TimS2025's avatar
TimS2025
Copper Contributor
Jan 02, 2025
Solved

Conditional Formatting on Data Range

Hi I am trying to set some conditional formatting on a row of data.  The row contains numbers from 1 - 52 with the cells changing based on project dates (so the number won't always be the same in th...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jan 02, 2025

    Let's say the data are in B2:Z2.
    Select this range. The first cell (B2 in this example) should be the active cell in the selection.

    On the Home tab of the ribbon, click Conditional Formatting > New Rule...
    Select 'Use a formula to determine which cells to format'.
    Enter the formula

    =OR(B2=4, B2=8, B2=17, B2=21, B2=30, B2=34, B2=43, B2=47)

    Click Format...
    Activate the Fill tab.
    Select a fill colour.
    Click OK, then click OK again.

    Repeat these steps, but with

    =OR(B2=13, B2=26, B2=39, B2=52)

    and another colour.

HansVogelaar's avatar
HansVogelaar
MVP
Jan 02, 2025

Let's say the data are in B2:Z2.
Select this range. The first cell (B2 in this example) should be the active cell in the selection.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula

=OR(B2=4, B2=8, B2=17, B2=21, B2=30, B2=34, B2=43, B2=47)

Click Format...
Activate the Fill tab.
Select a fill colour.
Click OK, then click OK again.

Repeat these steps, but with

=OR(B2=13, B2=26, B2=39, B2=52)

and another colour.

  • TimS2025's avatar
    TimS2025
    Copper Contributor
    Jan 03, 2025

    Thanks Hans - this worked, really appreciate you posting the solution ! :)

Resources