Want one cell to be highlighted if i type something in next one

Solved/Closed
Saurabhmitra07 Posts 2 Registration date Sunday October 20, 2013 Status Member Last seen October 20, 2013 - Oct 20, 2013 at 04:13 AM
Saurabhmitra07 Posts 2 Registration date Sunday October 20, 2013 Status Member Last seen October 20, 2013 - Oct 20, 2013 at 01:03 PM
Hello,

I want B1 to be highlighted as green if i type any text in C1.

Please help me.

Regards
Saurabh
Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 20, 2013 at 07:22 AM
Use CONDITIONAL FORMATTING:

At B1 -->

1st Condition: FORMULA --> =C1<>""
FORMAT --> Choose your desired color.
0
Saurabhmitra07 Posts 2 Registration date Sunday October 20, 2013 Status Member Last seen October 20, 2013
Oct 20, 2013 at 01:03 PM
Thanks Mazzaropi....it worked :D
0