• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting to be continued

S

santhurcv

Member
I need the Continued color coding using Conditional formating
Example which is Shown above
if I repeat the value 1 any where in the cell I need the Organe color to be highlighted till the end if there is no other value

attached is the sample file
 

Attachments

  • CF File.xlsx
    10.8 KB · Views: 2
Assuming conditional format required in column "R"
Go to Format > Conditional Formatting > Select Condition1 "Formula Is" & type below formula in next blank column. After that click on format & select color which you required. Copy & drag down.
=AND(COUNTIF($R:$R,R2)>1,NOT(ISBLANK(R2)))
 
Thanks a lot Atul and Soma !:)

@ Atul could you please let me know how does this work meaning can you please explain me on the same...
 
Last edited:
@ Atul i retried several time with actual data, but was not successful yet,, hence requesting you help here to do the same conditional formatting for the attached file.. please which is real data...
 

Attachments

  • CF File again.xlsx
    13 KB · Views: 3
@santhurcv

See the file, I had done for A1,A2,A10, you can repeat the same for all A's value.

CaUTION: Note CF is volatile and over such a big number of cell with around 20 different rule, you sheet may become slow.

Regards,
 

Attachments

  • CF File again.xlsx
    13.4 KB · Views: 4
Dear Santhurcv, If you describe in details i.e what is your criteria?, which data use alfa or numeric? etc, with sample file which you required actual result & with original some data. Its more clarity to me.
 
Hi Atul,

Please find the attached Original file requirements are as below.

This is Shift roaster where i would like to see the in which shift he is continue Color coding helps me for same.
i would need the same color for same person anywhere in the sheet.
.
 

Attachments

  • Original Data.xlsx
    11.8 KB · Views: 4
Dear Santhurcv
Refer your file. I suggest you if you change your data structure it may more help for you.
I have attach two format sample files.
Which file is more suitable for you, select.
Confirm your views.
 

Attachments

  • Original Data Santhurcv.xlsx
    37.2 KB · Views: 2
  • Original Data avk.xlsx
    263.4 KB · Views: 3
Really Appreciate your effort Atul,

But my Requirements are as below
1. Color for a Res# and the same Row needs to be highlighted with same color untill there is another Res#
2. Once i have the new res# on that row i want the color assigned to him/her has to be highlighted untill i see next res#..

This has to be done for A3 to A15
 
You must log in or register to reply here.
Back
Top