Conditional formatting for a group of cells

[j.mandall]

I am working on a project that is comparing budgets across multiple contracts and tracking any variance from the original template. The budget information for the template is in column B and columns c - z contain the contract budgets.

Is there a way to conditionally format the cells to make them change if they vary from the corrsponding row in the template? So, if F8 is greater then B8 it will be bold... but I want to apply that to all the cells in columns c - z.

Thanks for any help...

 

[nbrcrunch]

if the row numbers will change with each row, then:

=$F8>$B8

if the formula is only to look at row 8, regardless what row the format is on, then:

=$F$8>$B$8

 

[j.mandall]

I don't want to calculate the numbers... I am entering the data by hand and would just like the cells to be conditionally formatted so that if any number in a given row in columns c - z varries from the number in the same row in column b it will turn bold or a color. So i just want to do group conditional formatting.

 

[lenze]

Hi and welcome to the board!!
Select Columns C-Z, with C1 Active. in CF, use Formula Is

=(C1<>$B1)*C1

Select a format

lenze

 

[j.mandall]

Thanks Lenze, that worked perfectly! I appreciate your help on this.

 

[nbrcrunch]

Just for the record, the formula I gave you was for conditional formatting. It only resolves to true/false which is what you want for conditional formatting. However, it appears you got another solution for the answer you were seeking.

 

[j.mandall]

Thanks for your effort, it helped point me in the right direction, and I did find a formula that worked for me.

Thanks again!