itsrich
New Member
- Joined
- Apr 13, 2009
- Messages
- 49
- Office Version
- 2019
- Platform
- Windows
I am using Excel as a BOM. Some cells contain text others, this formula =IFERROR(VLOOKUP(A85,'P:\Fishbowl\FishBOM\[FishLINE.xlsx]FishLINE'!A:I,9,FALSE),"") The formula returns text from the DB. The cell should be in two states, text or a formula that returns text.
The conditional format I wish is:
Text, format the cell red.
Formula that returns text, format the cell blue.
My predecessor did me no favors in how he set things up.
TY for your knowledge!
The conditional format I wish is:
Text, format the cell red.
Formula that returns text, format the cell blue.
My predecessor did me no favors in how he set things up.
TY for your knowledge!