Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Can I shade a range based on the value of a cell outside range?

Status
Not open for further replies.
squirtguns

squirtguns

Technical User
Feb 18, 2000
4
US
Here is what I would like to do in excel...<br><br>Cell A1 contains a drop down box that can either be set to YES or NO<br><br>If Cell A1 equals the word NO<br>Then cells A2:A15 are shaded in grey<br><br>If Cell A1 equals the word YES<br>Then cells A2:A15 are not shaded<br><br>Any suggestions?<br><br>Thanks!<br>
 
Status
Not open for further replies.

Similar threads

N1GHTEYES
  • Locked
  • Question
Count areas within a range 1
Replies
14
Views
730
SkipVought
S
N1GHTEYES
  • Locked
  • Question
Count range overlap cells
Replies
3
Views
258
N1GHTEYES
N1GHTEYES
PSchubert
  • Locked
  • Question
Excel - SUMIFS() works with one range, but doesn't with another nearly identical range 2
Replies
6
Views
186
Andrzejek
Andrzejek
remeng
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
15
Views
956
combo
combo
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
182
ladyck3
ladyck3

Part and Inventory Search

Sponsor

Back
Top