If a1="x" And B1 is blank, then C1 is Yellow

[MrBill11]

Can anyone help with the above? I have tried to work this trough, but have not figured it out yet. If A1 and B1 are the same then C1 would have no formatting, but if A1 = "x", and B1 is blank, then I want C1 fill to be Yellow. This is my first post. Thanks in advance.

 

[pgc01]

Hi Bill
Welcome to the board

Use conditional formatting in C1 with the formula:

=AND(A1="x",B1="")

 

[Dryver14]

or if "x" is just a reference

=AND(A1<>"",B1="")

 

[MrBill11]

Thanks you two. What would the formula be like for numbers? If B1 was less than A1, then C1 fill yellow? And can you recommend any reference material on these types of formulas?

 

[Dryver14]

your welcome,

I am fairly new to this myself and learnt a lot from Excelisfun on youtube also I have the power excel 2007 cd from this site by MRExcel. both good starter points.

 

[MrBill11]

As you can tell I'm new too. I have ben doing the Excelisfun on you tube also, and am thinking of buying the slaying excel dragons book. Does the excel 2007 cd cover conditional format formulas? They seem to be different.

 

[Dryver14]

I think they both cover it at some point but look at the cd's etc on the front page of this site it states what they cover, conditional formatting formulas are the same as any others its just working out what you want the conditions to be and in what order to place them, try playing with it also I have found looking at boards such as these can be very instructive if you see a question then come back an hour later having worked it out to see that someone did it in 3 seconds can be quite amusing but also extremely rewarding if you have the same formula as them.....very rare in my case,
but I do find real live problems more motivating to learn than just trying to watch youtube, I often found I was copying what was going on and not understanding a thing.