Changing row colour based on Cell value

[StevenK]

I've started to try to utilise 'Conditional Formatting' in Microsoft Excel.

I'm able to change the background colour of a column dependent on whether the cell value is 0 or not.
Ideally I want to be able to do is to colour the contents of the whole row - rather than just the column (being conditioned on).

How can this be done?

For instance I might have a spreadsheet containing details of order transactions - and I'd want any rows that had a zero price against them to be coloured so that they stand out to the user.

Any help with this would be greatly appreciated.

Thanks in advance,
Steve

 

[Fenrirshowl]

Select conditional formatting as before. Select "Formula is" from the drop down box. You can then enter an IF formula for the selected cell based on any cell you like.
Eg

=if(A1=1,1,0)

then select the format you require for the TRUE result. You can use this technique for the entire row.

Hope this helps.

 

[GlennUK]

Remember to use absolute reference for the column, then the entire row will be formatted. So, select the table, do Format/Conditional Formatting/Formula Is ... =$D1=0 ... and choose a format.

( change $D to be $whatevercolumn , depending on which column contains the price )

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[StevenK]

Excellent - thank you both for your help with this.
I'm now up and running with the spreadsheet I require.

Thanks again.
Steve

 

[GlennUK]

Great :-D

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.