Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 23-10-2009
Member
 
Join Date: Sep 2009
Posts: 152
Writing a conditional formatting with Excel 2007

I just read the FAQs and tutorials but I am unable to write correctly the formula for a MFC that should be obvious to you all but impossible for the beginner like me. I just want to apply the MFC if the contents of the cell is equal to 1 or 2 or 3 or 4 or 5 or 6 or 7 or 8 or 9 or 10.

I do know the rules by creating 10 but I guess you can make one.
Reply With Quote
  #2  
Old 23-10-2009
Member
 
Join Date: Jan 2008
Posts: 1,515
Re: Writing a conditional formatting with Excel 2007

So you want the formatting applied to the value 'up to' 10, then chose this parameter instead of 'equals'
Reply With Quote
  #3  
Old 23-10-2009
Member
 
Join Date: Sep 2009
Posts: 152
Re: Writing a conditional formatting with Excel 2007

Thank you for your answer but it does not suit me because I can have values between each unit (1.25 or 4.5 for example) and then I want that formatting does not apply to the cell.
Reply With Quote
  #4  
Old 23-10-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: Writing a conditional formatting with Excel 2007

To adapt to your cell, choose New Rule/Use a formula and then enter the following formula

Code:
=(AND(A1>0;A1<11;A1-INT(A1)=0))
Reply With Quote
  #5  
Old 23-10-2009
Member
 
Join Date: Sep 2009
Posts: 152
Re: Writing a conditional formatting with Excel 2007

So I have a supplementary question. As I must extend this rule to thirty cells, Am I obligated to treat them one by one or is there a way to replace A1 by something else. (To "facilitate" all my cells are not grouped (from AL2 to AL6 then AL9 to AL13 and AL16 to AL20 and so on)).
Reply With Quote
  #6  
Old 23-10-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: Writing a conditional formatting with Excel 2007

You just select your entire range (ie all the Cell for what you need formatting) and then you type the formula through the first cell within your range

For example, if the first cell AL2 is selected, the formula becomes

Code:
=(AND(>0;AL2<11;AL2-INT(AL2)=0))
and while you watch it or cell names without $

And suddenly, it will retain the logic
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Writing a conditional formatting with Excel 2007"
Thread Thread Starter Forum Replies Last Post
Conditional formatting not getting updated automatically in Excel 2010 Vento Windows Software 3 28-04-2012 07:32 AM
VBA Conditional Formatting in Microsoft Excel Thedevotee MS Office Support 4 21-01-2012 02:12 PM
Excel Macros for conditional formatting statement in Excel Kungfu Pandey Microsoft Project 1 08-01-2012 08:35 PM
Microsoft Excel 2007 formatting Meditation Windows Software 4 29-01-2011 04:58 PM
Conditional formatting in excel RockeЯ Windows Software 4 27-06-2009 12:06 PM


All times are GMT +5.5. The time now is 03:50 AM.