Help with Excel Formula

nutmegman

Hi,

Does anyone know the excel formula to review three numbers and colour the cell in yellow for the highest value and green for the lowest value?

Thanks

Grumpy_Old_Duffer

nutmegman wrote: »

Hi,

Does anyone know the excel formula to review three numbers and colour the cell in yellow for the highest value and green for the lowest value?

Thanks

You need Conditional Formatting found under Format.

isofa

You should be able to achieve this using Conditional Formatting (Format > Conditional Formatting).

So if you have 3 numbers in A1, A2 and A3.

The formatting on A1, can compare itself to the number is A2 and A3, if it's greater than both, then change to colour 1, if it's less than A2 but greater than A3 then change to colour 2, if it's less than both A2 and A3, colour 3 etc.

nutmegman

Thanks for your help, at the moment i cannot get it to work.....

I have the folllowing numbers

200 500 750 for this row i would like it colour the cell green for 200 and red for 750

I then wish to copy the formatting for the rest of the sheet

Vomityspice

Look in

http://www.mrexcel.com/forum/index.php

use the search function before asking a question that has been repeated a million times!