# 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???  Register To Reply

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,  Register To Reply

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

Thank you for the quick reply,  Register To Reply

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