color based on formula

  • Thread starter Thread starter crapit
  • Start date Start date
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)
 
Hi 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)

Use Conditional Formatting with a formula like this
=FIND("+",A1)>0

This assumes that you have a text string like '4 9 +21' in cell A1

Ed Ferrero
www.edferrero.com
 
If you're looking to use a different font color for the last term (+21), then
you can't do this with with formulas.
 
Back
Top