Formula for a column fill color based on another column content

Hello everybody
I have a question .Just take a look to picture I have attached. I want to write a formula for entire of
"O" column for its cells fill color, based on "M" column cells value, If the value in "M" be 1, the
Cell fill color in "O" column in the same row change to YELLOW, if value be 2, color in "O" change to
RED and...
Also with changing the cell fill color can we change its fonts color to a bold withe color for example?
Thank you in advanced.


\1

http://www.mrexcel.com/forum/excel-q...ml#post4669659

First, your picture is such a low resolution that it is nearly illegible. An image attachment has very little value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that. Under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

You also have other colors in column O. Can you give all the rules you need?

You will need one conditional formatting rule for each color that you want in column O. Highlight the cells in O that you want the rule for (O2 up to the highest row you might use) and then go into Conditional formatting and select "Use a formula...". For example, for M=1:

=M2=1

and use the yellow fill color and bold font formatting.

If you attach your file I can implement this in your file for you as an example, then you can do the rest.

CF formula

Select O2

... Use a formula....

=m2=1

Fill==> Yellow

Applies to: $O$2:$O$200

Repeat for m= 2 to 4

Hello again and thanks all of you. I found my answer from somebody(Marcilio) and it works!
In this formula the header of column "M" which is M1 is considered so each rule applys to all
of cells in the column "M" and it is very nice I only need to creat 4 rules.

The answer :

The Conditional Formatting will do this task for you.
Try to use:

Select Colunm O
Conditional Format Menu --> Using Formula

Rule 1
=$M1=1
Format:Font Bold; Fill Color YELLOW
OK

Rule 2
=$M1=2
Format:Font Bold; Font color White; Fill Color RED
OK

Rule 3
=$M1=3
Format:Font Bold; Fill Color GREEN
OK
Create as many rule as necessary for your different Values.