Conditional Formatting 1

[robcarr]

Dear All,

I am currently using columns e,f,g,h to enter data in, if a conditional format is true, the colours change, what I am trying to do in column I is get a cell to change colour in column I if a criteria is met, I was wondering if you can check e,f,g and h and if the conditional format is true(colour changes) in any of the 4 columns column I also changes colour, I am currently doing this as a formula in the conditional format, but I get column I formatting when I don't require it to change.

Formula in conditional Format
=IF(OR(E13:F13>15.99,E13:H13="UNLIMITED",G13:H13>="32",E13:H13="compensation&quot,1,0)

The problem is that if a value of 32 or higher is entered in any of the range the conditional format doesn't work except for e and F as this is triggered by the first part of the IF, I can't set the 15.99 to check range e13:h13 as values in H13 could be lower than 32 and I only want 32 or higher in this range to trigger the format. I hope this makes sense.

This is why I would like to just format I if columns E,f,g or H conditional formats are true.

I have had a look around for coding but it is not making much sense to me.

Any help would be great on this.

Thanks

 

[sfvb]

You have 32 in quotes.

 

[RobBroekhuis]

Your conditional is quite complex, and probably needs to be a little more complex to do EXACTLY what you need it to do (which isn't quite clear to me from your write-up). Consider using a custom worksheet function to do the job, e.g.

public function Colored(r as range) as integer
Colored=r.range("A1&quot>15.99 or r.range("A2&quot>15.99 or ...
end function

and use the Colored function right in your worksheet.
Rob

 

[robcarr]

thanks for that, so simple when some else looks at it