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
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

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.