conditional formatting

  • Thread starter Thread starter KSP
  • Start date Start date
K

KSP

I am trying to import categorical data into a spreadsheet. I need the
categorical data to import as numerical values (i.e. white = 1, black = 2,
hispanic = 3, etc.)
Is there a way to do this using conditional formatting? If not, please offer
a different suggestion.

Thanks!
 
Nope, theres nothing you really can do with conditional formatting for this.
The only thing I can think of is just import the data, then in a new column
write out the formula to change those text values to numbers... like

If(A1="white",1,If(A1="black",2,etc

or you can put the numerical values next to the colors and use vlookup up,
such as

Vlookup(A1,array,2,FALSE)

Where the array is the list of colors and there values.
 
Back
Top