View Single Post
 
Old 07-09-2014, 09:35 AM
whatsup whatsup is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

Hi

Now, I didn't have a very close look to your code, but one thing isn't correct:
Code:
Formula1:="=IF(AND($I3>$S$1,$I3<$U$1),$I3,"""")"
I gave you yesterday the formula, and maybe it looked odd to you that it will work. But it will:
=AND($I3>$S$1,$I3<$U$1)

The thing is, excel expects a result either True or False. On just this result it's decided if the format gets applied or not.
The formula you use returns a result, the else-part returns text (empty string). In case your result is numeric, every number > 0 is interpreted as True. A emtpy string maybe will bring up some confusion.

Another thing, you will have to check:
Inserting a formula when references aren't absolut is a tricky thing. Your reference $I3 might change the reference of row 3 to another row, in case a cell is selected not within row 3.
Reply With Quote