|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
11-17-2006, 08:14 AM
|
|||
|
|||
|
Conditional Formatting not working?
Hi there,
me again! Now I'm an expert on conditional formatting(  ) I've tried it on a new file however, whilst it shows as set (see attached file), it isn't working!Anyone any ideas why it would not? Cheers. 
|
|
#2
11-17-2006, 09:37 AM
|
|||
|
|||
|
well without seeing the file and the values its hard to say
The most likely reason is the values are actually text and hence do not meet the criteria and fall in the range. if the first value is in cell a1, choose formula try =and(a1>0.5,a1<0.7) as the first condition etc Regards Dav
|
|
#3
11-17-2006, 09:40 AM
|
||||
|
||||
|
Quote:
__________________
oldchippy -------------   Click here >>> Top Excel links for beginners to Experts Forum Rules >>>Please don't forget to read these
|
|
#6
11-17-2006, 10:00 AM
|
||||
|
||||
|
When you enter numbers into a cell, even percentages, they default to the left. Text defaults to the right, yours are to the left, but looking at the left icon on your word.doc, it doesn't look depressed???
__________________
oldchippy ------------- Click here >>> Top Excel links for beginners to Experts Forum Rules >>>Please don't forget to read these
|
|
#7
11-17-2006, 12:05 PM
|
|||
|
|||
|
Quote:
Well if you can zip the word document, you just do the same thing to zip the excel file. Regards Dav
|
|
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
