Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# Excel AAAAHHHHH

### #1 MattyJ09 Posted 14 October 2010 - 06:34 AM

MattyJ09

New Member

• Member
• 2 posts
Is it possible to create a formula so that if a1 is the destination cell and b1=yes then a1 will turn red? step by step instructions would be very grateful as I am terrible at excel!
• 0

### #2 MattyJ09 Posted 14 October 2010 - 06:42 AM

MattyJ09

New Member

• Topic Starter
• Member
• 2 posts
Is it possible to create a formula so that if a1 is the destination cell and b1=yes then a1 will turn red? step by step instructions would be very grateful as I am terrible at excel!

One caveat on this b1 will only show yes if it is equal to or greater than the sum of d1,e1,f1,....so on and so on...
• 0

### #3 Vino Rosso Posted 14 October 2010 - 07:46 AM

Vino Rosso

Visiting Staff

• Visiting Consultant
• 235 posts
Instructions depend on version of Excel.

With cursor in A1, Format > Conditional Formatting...
Condition 1
Use drop-down to select Formula Is
In next box type =\$b\$1="yes"
Click Format... button
Click Patterns tab
Select red
OK > OK
• 0

### #4 Crowbar Posted 14 October 2010 - 07:48 AM

Crowbar

Teacher

• GeekU Moderator
• 4,017 posts
I think you want to look into conditional formatting, read this http://www.mrexcel.c...-formatting.php and do a google search for conditional formatting. I find that the help file in excel also explains conditional formatting pretty well.

Hope this helps you out a little.
• 0

### #5 beckmancameron Posted 23 October 2010 - 08:09 AM

beckmancameron

Member

• Member
• 14 posts
Is there anybody help giving sites where I can get tutorial(free) on excel (basically more on macro)?
• 0

SpywareDr

Member 2k

• Member
• 2,855 posts
• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users