Can color codes be used in formulas to seperate data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pay sheet that has a cell that we use for leave can I use colors
i.e. red=sick leave blue=annual leave green=leave without pay and hve it
transfer that information to the appropriate column in another document in
excel?
 
Back
Top