|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.