Solved Formatting one cell to affect another.

June 24, 2011 at 10:47:35
Specs: Windows XP
When I am entering data into D5 I want it to turn the data in A5 red. Can't seem to figure out the formula, can anyone help me?

See More: Formatting one cell to affect another.

Report •


#1
June 24, 2011 at 11:07:33
What exactly are you trying to do?

1 - Do you want the data in A5 to turn red after you have entered data in D5?

2 - Do you want the data in A5 to turn red as soon as you select D5 and start entering data?

3 - If it's #2, do you want the data in A5 to remain red after you enter the data or do you want it to go back to white once you select another cell?

4 - Is it only A5/D5 that you are interested in or do you want this to happen to multiple cells?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
June 24, 2011 at 11:37:23
right now the date is entered in A5 and this is where i placed my cursor for conditional formatting. I would like the date to change red after there is something entered in either D5 or F5.

I believe the format would be =NOT(ISBLANK(D5))

I can't figure out how to inclue F5 into the formula as well. I don't want to do another condition for it because they tend to create conflicts.


Report •

#3
June 24, 2011 at 11:47:45
✔ Best Answer
Try this. It will return TRUE whenever there is data in either D5 or F5 or both.

=OR(NOT(ISBLANK(D5)),NOT(ISBLANK(F5)))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
June 24, 2011 at 11:55:12
It totally worked perfect. My co-worker said to give you a kiss... so I'm sending hugs and kisses and many thanks.

AWESOME!


Report •

#5
June 24, 2011 at 18:31:13

Report •


Ask Question