Format a cell based on value in another cell

**DivineLTG** · 06-10-2010, 11:12 AM

I am have been trying to figure out how to apply contitional formatting on one cell ONLY when another cell is not empty. So, if A1 contains data, then apply a red border around F1... If A1 is blank, then DO NOT apply any border to F1

**NBVC** · 06-10-2010, 11:14 AM

Select F1 and invoke CF... then pick formula is from drop down and enter formula:

=A1<>""

then format.

**DivineLTG** · 06-10-2010, 11:36 AM

I am so sorry, I left out a piece of information. A second condition that needs meeting before the border is applied. F1 also needs to be blank. So, if I enter data into A1, then F1 receives a border. But then once data is entered into F1, the border should go away.

**NBVC** · 06-10-2010, 11:39 AM

Replace the formula I gave with:

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

**h2count** · 01-26-2012, 06:03 PM

I searched and read, and searched and read, and finally the answer I needed was in your reply to the previous post (a year and a half ago) - thanks for helping me out, too!

**h2count** · 01-26-2012, 06:12 PM

I searched and read, and searched and read, and finally the answer I needed was in your reply to the previous post (a year and a half ago) - thanks for helping me out, too!

HOW DO I DELETE A POST FROM THIS FORUM?