#1




Excel Conditional Formatting Question
Hi All
I wonder if the below is possible. I have a Excel 2013 spreadsheet with around 50 rows, and about 5 columns like so.... essentially column E shows the difference in percentage between the numbers in column B and Column C. What I would like to do is make an individual cell either another colour or bold depending on if that percentage is above a certain value, so for example... I set it so colum E will highlight in green everything over 25%, I would then liek to automatically bold and/or colour the cells in column A to reflect that. Is this possible? 
#2




A3: =E3>=50% and use paintbrush to apply remainder of column.
E3: Format only cells that contain … , Cell value / greater than or equal to / =0.5 
#3




Thanks for your reply, however I dont know how to actually implement this in an excel document. Ill needs the A Column to keep the name of the item in there, So in A3 there maybe Widget 1, I need the word widget 1 to stay there but be highlighted if A3 is over the threshold set.

#4




The formula is entered as conditional formatting rule condition, not into worksheet cell! Select the range with data (e.g. A3:A12), then activate Home menu, select Conditional Formatting and then New Rule (or when some rules are defined, then Manage Rules). For new rule select Use a Formula ...  and now enter the condition formula for left topmost cell of selection (be aware of use $ signs for cell references  in your case it must be $CR, like $E3). Then click Format and set there how cell is displayed when the condition is TRUE, and press OK until done!

#5




Thre is something I am not doing right here.
So on an individual cell the formula that I have entered works. How can I get that to work over Multiple cells, where the % in column E differs (I hope ive explained that correctly) ive tried using format painter but that doesnt work 
#6




See 2 conditional formatting in columns A and E of the attached.

#7




Hi, Thanks for this and I can see the conditional formatting and it does indeed work.
I am trying to understand the formula in order to learn how to do them better, no matter what cell I click in on the A Column, when I look at the formatting for that cell is says Rule =$E3>25% Applies to =$A$3:$A$12 I notice there isnt a $ to the left of the E under rule so does that mean the rule is looking always at column E but the number will change on each subsequent cell, so E4, E5, E6 etc, even though the conditional formatting on each cell only shows E3 
#8




Yes it does.

Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Conditional Formatting deleted by excel when saving and reopening file  sazetts  Excel  7  02092017 10:52 AM 
Question re: Conditional formatting (cell occurs after another cell)  Saywarder  Excel  1  04202015 11:29 AM 
Conditional formatting question based on cell date  Cosmo  Excel  2  04082013 12:12 PM 
Conditional Formatting Problem Excel 2007  namedujour  Excel  6  08042011 10:52 AM 
Conditional formatting of cell, Excel 2003  Scaffold  Excel  2  05012010 08:56 AM 