# Conditional Formating using a formula to determine what cells to format.

1. ## Conditional Formating using a formula to determine what cells to format.

I need help creating a formula for conditional formatting.

I have 3 cells with 3 numbers. What I need is a formula to take the lowest number, multiply that by 1.5. This result is the MAX number the other 2 numbers can be. If any of the other numbers goes above the MAX, I need the cell to be highlighted.
So anything: >((lowest number of the 3 cells)*(1.5))

For example:

My 3 numbers: 10, 13, 33. With 10 being my lowest number, that would be 10*1.5=15. Any number above 15 needs to be highlighted. In this case, the cell with 33 should be highlighted.

Is there a way to conditionally format these cells to do this???

2. ## Re: Conditional Formating using a formula to determine what cells to format.

Assume your three numbers are in the cell range A2:C2, then select A2:C2, and with Conditional Format, use the formula:

``Please Login or Register  to view this content.``
Cheers,

3. ## Re: Conditional Formating using a formula to determine what cells to format.

Thank you for the quick reply,

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1