Conditional formatting not working after certain point in the sheet
Hi all,,
As the title says my conditional formatting has stopped working properly at a random point down my sheet.
Not sure whats causing this.
The formatting should highlight the column a orange when there is a '2' in column K. (as demonstrated in the second image)
The problem is depicted in the second image, where '2' is in column K yet the formatting isn't right, and even have different cells highlighted.
The condition formatting I have is =$K2=2
Can anyone advise?
Cheers
Last edited by Treeman_JF; 06-09-2020 at 05:59 AM.
Please post a sheet ( see yellow banner)
Sheet now attached to original post, thanks
Your formatting applies to the following ranges =$A$2:$N$6;$M$7:$N$82;$A$7:$K$74;$A$75:$H$82;$I$75:$K$96;$P$2:$P$11;$L$7:$L$165 ( don't bother about the semi-colons)
Is this correct?
Basically I want whenever a '2' appears in column K, the intersecting row to be highlighted orange, throughout the whole sheet (Lets say to row 1000).
I'm not sure if I set it up properly to begin with.
Like this ?
You'll have to extend the range or use the Excel Table tool ( which is the easiest way IMO)
Select your entire range - Insert - Table - Check " My table has headers" - OK
Remove the default formatting in the Table style options
Select the entire range again and create the CF as above.
Now when addin a row, the CF range is automatically adapted
Last edited by arthurbr; 06-09-2020 at 06:30 AM.
Ah yes, that how it's meant to be. I think I figured out where I went wrong too. Many thanks!
See post #7 I was adding something while you answered
And be careful when editing the CF range box, strange things happen there...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks