Forum Discussion
Conditional Formatting each row individually
Hi - I am currently trying to apply conditional formatting to my entire worksheet to show the min and max of each row individually. Is there a way to apply this to the entire worksheet while still k...
HansVogelaar how can you amend this so that the top 5 and bottom 5 values in each individual row are highlighted? Also, my data sheet is right to left (orientation) and the first cell with relevant data that needs to be formatted is k2, does that matter at all?
The steps should be the same, with the formulas
=AND(A1<>"",A1<=SMALL(1:1, 5))
and
=AND(A1<>"",A1>=LARGE(1:1, 5))