Conditonal Formatting (When a number appears, the cell to the right changes color)

[managingcrap]

I'm trying to figure out a conditional formatting where if I have cell A1 as 1, then B1 will have a black color ( the cell block colored black). However, if i leave the A1 blank, then B1 is not colored.

I tried conditional formatting and failed.

Please see attached sheet.

[TMS]

CF Rule:

Please Login or Register  to view this content.

Regards, TMS

[managingcrap]

I apologize I made a mistake. What I was wanting to do is if the cell is blank, then the cell is colored. If it's not blank, then the cell is not colored. Please help.

Thanks.

[TMS]

Bit of a turnround

Please Login or Register  to view this content.

[Punnam]

HI,


Try this

Punnam

[TMS]

@Punnam: you don't really need an IF formula, just something that evaluates to TRUE or FALSE, hence, =B3=""


Regards, TMS

[Punnam]

@Punnam: you don't really need an IF formula, just something that evaluates to TRUE or FALSE, hence, =B3=""


Regards, TMS

Hi TMS,

1) First thanks for u r guidance.
2) So can i close any if condition without true or false ?

Punnam

[TMS]

@Punnam: you just need the condition part, you don't need the TRUE or FALSE, or even the IF( bit.

B3="" will be either TRUE or FALSE; just a simple comparison. See post#2 for another example.

Regards, TMS

[Punnam]

@ TMS :

Thankyou for explanation .

Punnam

[TMS]

@Punnam: You're welcome. Thanks for the rep.

[managingcrap]

[SOLVED]

Thanks all of you geniuses. You're all awesome.

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.