Color data based on data in another cell

[maunettia]

I am using Microsoft Excel and cannot figure out how do you make the data in one cell have a certain color based on the data in another cell?

 

[JoeMo]

Look at Conditional Formatting in Excel Help.

 

[maunettia]

With conditional formatting I know how to make certain text a certain color but not based on data in another cell.

 

[JoeMo]

Post an example of what you want to accomplish.

 

[maunettia]

Say cell A1=RC or A1=4mth

IF A1=RC THEN B1's data is a formula and the result needs to be red (not the cell the data needs to be written in red)
IF A1=4mth THEN B1's data is a formula and the result needs to be blue (not the cell the data needs to be written in blue)

I really appreciate the help.

 

[JoeMo]

Select cell B1 then go to your menu and choose Conditional Formatting/New Rule/Use a formula.
In the formula box enter:

=$A1="RC"

Then format the font to be red.
Repeat this process for 4mth:

=$A1="4mth"

Format font to be blue.

 

[maunettia]

YOU ARE AWESOME! I AM A SELF TAUGHT EXCEL'R AND MAINTAIN A SPREADSHEET AT WORK. I DID ALL THE FORMULAS AND REALLY LOVE SPREADSHEETS. THEY ARE SO MUCH FUN! I JUST REALLY WANT TO SAY HOW MUCH I APPRECIATE YOU.