• 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

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

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

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