C
crapit
I'm using vlookup to extract number from another spreadsheet such that it
give e.g 4 9 +21. How do I set a specific color if a + prefix attach to a
number?
=VLOOKUP(B1,'Past'!A4:BE999,55,FALSE)& " " &
VLOOKUP(B1,'Past'!A4:BE999,56,FALSE)& " +" &
VLOOKUP(B1,'Past'!A4:BE999,57,FALSE)
give e.g 4 9 +21. How do I set a specific color if a + prefix attach to a
number?
=VLOOKUP(B1,'Past'!A4:BE999,55,FALSE)& " " &
VLOOKUP(B1,'Past'!A4:BE999,56,FALSE)& " +" &
VLOOKUP(B1,'Past'!A4:BE999,57,FALSE)