conditional formatting

[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!

 

[akphidelt]

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.