See example attached. Example.xlsx
I need to highlight the lowest value by row in cols A, C & D but not B. I can do the first row but can't copy it down the rows.
See example attached. Example.xlsx
I need to highlight the lowest value by row in cols A, C & D but not B. I can do the first row but can't copy it down the rows.
Please see attached file. Highlight the first range go CF and select Bottom select 1 from drop down menu. Do the same for each range.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
CF = Conditional Formatting
Yes I understand how to CF - I did the first row no problem. But with 500+ plus rows to CF, I want to find a way to do that in one operation rather than row by row. Hence my original question about copying it. And the fact that the columns are not adjacent doesn't seem to be helping. (also in your example there is a problem with row 1 - two cells highlighted, and row 5 - all cells are highlighted).
Last edited by Thistledown; 06-12-2014 at 04:04 AM.
If you read my post#2 it says to highlight the first range not first cell. You should select the entire range (A1:A500). Also, you apply CF to the columns not to the rows. If column 'A' has two smallest values that are the same, then both of them will be highlighted and if there are 6 then all six will be highlighted.
OK, a complete misunderstanding, I see. Maybe I didn't explain correctly in my opening post. I do not want the lowest value per COLUMN, but per ROW. Therefore in row 1, A1 should be highlighted as £29.70 is the lowest value in that ROW (ignoring col B as I said originally).
Please see attached updated file. To review rules please go to CF, Manage rules, Edit rule
Thank you - your formula has cracked it - and I can just use 'applies to' in edit CF to select range to be CF'd.
Last edited by Thistledown; 06-12-2014 at 09:30 AM.
You're welcome and thank you for the feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks