Search:

Type: Posts; User: harky; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    58

    Questions on conditional formatting

    Hi,
    Possible to use conditional formatting to 'sum count' font colour?

    1
    2

    The ans should be 2 'count'
  2. Re: VBA apply conditional formatting to another cell base on

    Thanks!

    I manage to get it.

    =Len(C1)>3
  3. Re: VBA apply conditional formatting to another cell base on

    what is the formaular for not wanted to hightlight 3 digital number?
  4. Re: VBA apply conditional formatting to another cell base on

    tested.

    thank u so much
  5. Re: VBA apply conditional formatting to another cell base on

    Is tht possible to highlight both side?

    Col B & Col F?
  6. Re: VBA apply conditional formatting to another cell base on

    oh haha..

    i dont know tht can be done like this.
    i sound silly.

    Thanks
  7. Re: VBA apply conditional formatting to another cell base on

    something like below?

    each range used diff colour.
  8. Re: VBA apply conditional formatting to another cell base on

    <tbody>
    A
    B
    C
    D
    E
    F


    001
  9. Re: VBA apply conditional formatting to another cell base on

    highlight is at Col B

    data is located at Col F

    The reason is Col B cannot use formula, is like a data of code number so i cant use it.
  10. Re: VBA apply conditional formatting to another cell base on

    The data which i want to highlight is at Col B
    but i cant use Col B on conditional formatting because there is no range data (number).

    My range data is located at Col F
  11. VBA apply conditional formatting to another cell base on

    The conditional formatting is base on Col F to change colour.

    But due to Col B is not in a range so i cant use conditional formatting.

    Possible to use VBA apply conditional formatting base on...
  12. Replies
    15
    Views
    271

    Re: VBA draw table line borders every 18 count

    Yes, ur does what i want.. Thanks both :)
  13. Replies
    15
    Views
    271

    Re: VBA draw table line borders every 18 count

    Thanks, but it has error @ last line.

    Erase Arr
  14. Replies
    15
    Views
    271

    Re: VBA draw table line borders every 18 count

    Thanks!
  15. Replies
    15
    Views
    271

    Re: VBA draw table line borders every 18 count

    yes this!!

    but can i start from T22 row? as Row 1 to 21 is so call header.

    Can change the line to thicker type?
  16. Replies
    15
    Views
    271

    Re: VBA draw table line borders every 18 count

    this only do top few row?

    but i had thousand row with data.
  17. Replies
    15
    Views
    271

    Re: VBA draw table line borders every 18 count

    cant be done? ? ? ? ? ? ? ?
  18. Replies
    15
    Views
    271

    Re: VBA draw table line borders every 18 count

    https://i.imgur.com/whKE0OP.png
  19. Replies
    15
    Views
    271

    VBA draw table line borders every 18 count

    I not sure if it possible?

    VBA draw table line border every 18 count from col T to AF



    <tbody>

    COL T
    COL U
  20. Re: Change fill color based on the value on sheet2

    Think i use this. Thanks bro!
  21. Re: Change fill color based on the value on sheet2

    thanks!
    was thinking if possible, dont want to use macro.

    Is conditional format the only way?
  22. Re: Change fill color based on the value on sheet2

    There are many data on sheet1 & 2 but i will show 5 here for example

    Sheet1

    <tbody>
    Col A


    0.1
  23. Change fill color based on the value on sheet2

    Sheet1 is data
    Sheet2 is data with fill color

    Abit hard to use conditional Formatting as i have at least 411 data with fill color


    Is there anyway to do it?
  24. Replies
    12
    Views
    193

    Re: Macro VBA: Check If Column is empty

    Thanks! this work great :)
  25. Replies
    12
    Views
    193

    Re: Macro VBA: Check If Column is empty

    Thanks! I change but still not working

    there is no empty cell on D. The marco is not running.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4