Conditional formatting

Copper Contributor

I know how to use conditional formatting to highlight a specific value in a column Ex:  all instances of 4 in column D will be purple, but how do I use / is there a way to apply conditional formatting to highlight multiple specific numbers , ex: 7.18, 12.45, 8.69 in green,  6.84, 14.22, 21.65 in orange, so as not to have in this example 6 rules but only 2.   Hopefully this makes sense.

1 Reply

@Stephen2532 Select column D and create a formatting rule using a formula like:

=OR(D1=6.84,D1=14.22,D1=21.65) and apply it to the entire D column.