Solved

conditional formatting formula

Posted on 2014-01-07
4
242 Views
Last Modified: 2014-01-07
Hi Expert's

Need a conditional formatting formula is if cell a2 and cell b2 are blank then grey out cell c3
0
Comment
Question by:route217
  • 2
4 Comments
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 250 total points
ID: 39761976
=AND(A2="",B2="")
should work.
0
 
LVL 23

Accepted Solution

by:
Danny Child earned 250 total points
ID: 39761989
Select Cell C3
Conditional Formatting button.. New Rule.. Use a Formula To Determine Which Cells to Format..
and enter this formula
=AND(ISBLANK(A2),ISBLANK(B2))
 - choose the formula you want to apply.

Use the Format Painter to apply this elsewhere.
0
 

Author Comment

by:route217
ID: 39762032
Excellent feedback. ..many thanks
0
 
LVL 23

Expert Comment

by:Danny Child
ID: 39762784
of course
"choose the formula you want to apply"
should read
"choose the format you want to apply"...

but thanks for the points anyway!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

943 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

5 Experts available now in Live!

Get 1:1 Help Now