I'd like to have the highest and lowest values in a row be a different colour than the rest of the cells. This is a simple conditional formatting issue when there is only one line. The problem is I want to do it for many rows but if I select all the rows to make the rule it only gives the highest and lowest of the whole selection. Is there a way to copy a rule, or create a rule shortcut so I can apply the rule to each row?
Thanks
use a formula
so assuming the row is column A to J
Select columns A to J
then use conditional formatting
Formula
=A1=MAX($A1:$J1) - format the colour you want
and
=A1=MIN($A1:$J1) - format the colour you want
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I'm not sure this does what I'm looking for or that I follow the suggestion. What I want is the highest and lowest in row a to be certain colours, and the same thing for b, c etc.
That is exactly what this CF does...
Interesting. This formatting ( =Q54=MAX($Q54:$T54) - blue ) seemed to turn the cell blue but instead of a number in the cell it said #name?
Does anyone know what the problem might be?
How did you apply the CF ?
I just pasted this into the cell =Q54=MAX($Q54:$T54) - blue
=Q54=MAX($Q54:$T54)
What Range are you looking for
Q to T
for 2007 or 2010 excel version
Conditional Formatting
Highlight applicable range >>
Q:T
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=Q1=MAX($Q1:$T1)
Format… [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK
How about the answer at your duplicate post?
http://www.excelforum.com/word-forma...ml#post3880459
Entia non sunt multiplicanda sine necessitate
etaf's explanation is great. Here is a workbook that has an example using his formulae in the Conditional Formatting and another example using the same logic but different functions. The cell references are changed only to match the examples given.
I added a small edition to etaf's solution added rule =A1="" and formatted No Colour
Oops....file munged up.
Un-munged
Last edited by newdoverman; 10-28-2014 at 05:04 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks