Clever Geek Handbook

Multifunctional Conditional Formatting Range

I want to give a quick indication using colored cells of the time that can be taken to complete the task. For example:

if cell B2 = 1, then fill the range of cells G2: H2 with light red; if cell B2 = 2, then fill the range of cells G2: J2 with light red; if cell B2 = 3, then fill the range of cells G2: L2 with light in red

How can I achieve this?

+3


source to share


2 answers


Select G2: H2 and use the CF formula rule:

=$B$2=1

Select G2: J2 and use the CF formula rule:

=$B$2=2


Select G2: L2 and use the CF formula rule:

=$B$2=3

each with the formatting of your choice.

+1


source


If you want a dynamic formula and only one format , you can select all the cells you want to format and then create a new conditional formatting rule using the formula:

=$B$2*2+COLUMN($G:$G)-COLUMN()>0


Which will affect 2 extra cells every time you increase $B$2

. I used your examples $B$2

and am starting with $G:$G

, but you can change them if needed.

If you need multiple format settings, this won't work.

+1


source






More articles:


All Articles