itsrich
New Member
- Joined
- Apr 13, 2009
- Messages
- 49
- Office Version
- 2019
- Platform
- Windows
I want the cell containing the following formula to change the fill color when the formula results in a date. =IF(ISBLANK(INDEX('Where is production'!$G:$N,MATCH('The Time Line CURRENT'!D3,'Where is production'!$D:$D,0),5)),"",INDEX('Where is production'!$G:$N,MATCH('The Time Line CURRENT'!D3,'Where is production'!$D:$D,0),5))
The result of the formula is text or number
Currently, I am attempting to use conditional formatting to format the cell, but the text and numbers are formatted the same. I can figure out how to determine the difference between a number and text.
TY for your help
The result of the formula is text or number
Currently, I am attempting to use conditional formatting to format the cell, but the text and numbers are formatted the same. I can figure out how to determine the difference between a number and text.
TY for your help