Excel_Noob_2019
New Member
- Joined
- Dec 6, 2019
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hello!
I have 2 columns of data, one with a Value and the other with a date. The Value is computed based off this formula: "=IF(L16>J16,"1","")&IF(ISBLANK(L16),"0",""&IF(L16=J16,"ON TIME","")&IF(L16<J16,"EARLY","")). Now I am trying to change the color of L16 to red if the first is true.
Essentially, if = 1, change other cell color to red.
I have not been able to figure out how to do this.
I have 2 columns of data, one with a Value and the other with a date. The Value is computed based off this formula: "=IF(L16>J16,"1","")&IF(ISBLANK(L16),"0",""&IF(L16=J16,"ON TIME","")&IF(L16<J16,"EARLY","")). Now I am trying to change the color of L16 to red if the first is true.
Essentially, if = 1, change other cell color to red.
I have not been able to figure out how to do this.