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

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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