Aug 04 2021 08:52 AM
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.
Aug 04 2021 09:04 AM
@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.