Need Help With A Formular

[ximen]

Hi everyone,
Please could any one help me to formulate this function.
If the value in Cell X is smaller than 25 then Cell Y will be in gree
colour; and
if the value in Cell X is bigger than 25 smaller than 50 then Cell
will be in orange colour; and if the value in Cell X is bigger than 5
smaller than 75 then Cell Y will be in red colour; and if the value i
Cell X is bigger than 75 then Cell Y shall be in black colour. Man
Thanks for anyone who be able to help.
Best Regards

 

[Max]

Here's one way to try out via conditional formatting (CF) fromulas

(This assumes col B will be filled with a default "green" color as the "4th"
condition, as CF allows only a maximum of 3* conditions)

Select col B, and format it with green fill color

With col B still selected,

Click Format > Conditional Formatting

Make the settings:

Condition1
Formula Is| =AND(A1>=25,A1<50)
Click Format button > Patterns tab > Orange > OK

Condition2
Formula Is| =AND(A1>=50,A1<75)
Click Format button > Patterns tab > Red > OK

Condition3
Formula Is| =AND(ISNUMBER(A1), A1>=75)
Click Format button > Patterns tab > Black > OK

Click OK at the main dialog

(Note that I've revised your criteria a little tighter to close gaps
in-between)

Test it out by inputting various values within several cells in col A to
trigger the various colors in the corresponding cells in col B

*Do check out JE's page for up to 6 colors w/o macros:
Getting 6 conditional font colors without macros
http://www.mcgimpsey.com/excel/conditional6.html

 

[Max]

Note that the default fill color (green) will take care of your 1st
criteria, i.e. values in col A less than 25. This assumes, of course that
col A will always contain numbers, and/or that empty cells or cells with
text are "considered" equivalent to zero.

 

[Max]

Just in case you're having difficulty deciphering the distortions to the
suggested CF formulas from where you're reading the responses, try this link
instead:
http://tinyurl.com/6xpr5