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.
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.
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
The values look like text, as they automatically have formatted to the left looking at the alignment iconOriginally Posted by fnaclew
oldchippy
-------------
![]()
![]()
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Hi,
Why don't you zip the exel file itself ... ?
You would get more precise answer ...
Carim
![]()
Hi there,
Would gladly send as zip file but don't know how hence copied screen shot to word file then zipped.
oldchippy, doesn't say is 'text' format, says 'general'.
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???
Originally Posted by fnaclew
Well if you can zip the word document, you just do the same thing to zip the excel file.
Regards
Dav
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks