Relate formating with an IF then statement

acbigcheese

New Member
Joined
Nov 23, 2005
Messages
2
I am curious to know if excel has the capability of changing formating (shading in particular) to a specific group of cells through an If Then statement or by other means.
ie
IF B23 = Indiana then AF62:AF90 turns grey
Any input would be appreciated
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
Use conditional formatting.

Select AF62:AF90, then go select conditional formatting from the Format menu.

Enter:

Formula is | =$B$23="Indiana"

and use the "format" button to set your shading, etc.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,080
Members
412,566
Latest member
TexasTony
Top