Conditional formatting accross more than one collumn. dependant on specific word

[TheMaggot]

Hi,
I have been building a database for my small business for the book keeping

I am currently using:
Windows 7 64bit
Microsoft Excel 2010

Basically I have a price column and a Income/Expense column. I want the currency value in the price column to be red text if the word in the Income/Expense field is Expense.

I have done a lot of searching and found a few different things on changing whole rows, and more complicated formulas for if the data changes but mine will be constant.

I have been able to create a formula to create a sum for the total depending on whether an expense or income by

' =SUMIFS(C:C,D:D, "Income") ' but cannot figure out how to use more than one column with the conditional formatting.

Any Help much appreciated, I haven't used excel since school so I have a lot of learning to do.

Kind Regards

 

[thatoneguy650]

Highlight the Column with The price in it then go to conditional formatting and add a new rule. Put =$B1 = "Expense" in the formula and change the color. I assumed the Income/Expense column was column B, but you can change the B to any column.

 

[TheMaggot]

Thank you so much for that. So you highlight the column you want to be affected by the conditional format, and put the condition in the formula is this correct? Just so I understand why it works.

Worked a treat though thanks