Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Aug 01, 2023

How to color specific bits in all rows with a Single command or a Function?

Dear Experts,

                   I want to color the specific bits(bit0~1, bit2~6,....) like in the attached sheet, but want to do for all rows how can this be achieved for all rows?

Thanks in Advance,

Br,

Anupam

 

excel
Formulas and Functions

3 Replies

  • nimesht's avatar
    nimesht
    Iron Contributor
    Aug 02, 2023
    Do you mean you want to color the columns 2-5 based on the color of digits in column 1?
    It won't be easy as there is no direct formula. It can be done (probably) using VBA Macro.
  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    Aug 02, 2023

    anupambit1797 

     

    'How about online sql?

    create temp table aa as
    select rowid,highfont(substr(Column1,1,2))||highfont(substr(Column1,3,3),'blue')||highfont(substr(Column1,6,5),'pink')||highfont(substr(Column1,11,2),'grey') dyn,highfont(substr(Column1,1,2)),highfont(substr(Column1,3,3),'blue'),highfont(substr(Column1,6,5),'pink'),highfont(substr(Column1,11,2),'grey') from color_the_specific_bits;
    select "'"||dyn dyn from aa;

     

Resources