

 Thread Tools  Search this Thread 
#1
 
 
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. 
#2
 
 
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' 
#3
 
 
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. 
#4
 
 
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;A1INT(A1)=0)) 
#5
 
 
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)). 
#6
 
 
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;AL2INT(AL2)=0)) And suddenly, it will retain the logic 

Tags: conditional formatting, excel 2007, mfc, microsoft excel 
Thread Tools  Search this Thread 

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  28042012 07:32 AM 
VBA Conditional Formatting in Microsoft Excel  Thedevotee  MS Office Support  4  21012012 02:12 PM 
Excel Macros for conditional formatting statement in Excel  Kungfu Pandey  Microsoft Project  1  08012012 08:35 PM 
Microsoft Excel 2007 formatting  Meditation  Windows Software  4  29012011 04:58 PM 
Conditional formatting in excel  RockeЯ  Windows Software  4  27062009 12:06 PM 