Conditional Formating Help

[JFOXYGOLD]

So im making an inventory sheet and i would like for a cell (the whole row would be great) to highlight a color

so im having trouble writing the formula

im trying to make it so if the number in cell "B" is lower than "C" and "I" = Yes it highlight the cell(or row if possible)




[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]Product[/TD]
[TD]inStock[/TD]
[TD]Reorder Lvl[/TD]
[TD]Sold[/TD]
[TD]Sold For[/TD]
[TD]Cost[/TD]
[TD]Profit[/TD]
[TD]Cat.[/TD]
[TD]Reorder[/TD]
[/TR]
[TR]
[TD]Hand Warmers[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD]$3.00[/TD]
[TD]$1.50[/TD]
[TD][/TD]
[TD]Winter[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Foot Warmers
[/TD]
[TD]11[/TD]
[TD]10[/TD]
[TD]12[/TD]
[TD]$3.00[/TD]
[TD]$1.60[/TD]
[TD][/TD]
[TD]Winter[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]

 

[FryGirl]

Try

Conditional Formatting

• Highlight applicable range >> $A$2:$I$3
• Home Tab >> Styles >> Conditional Formatting
• New Rule >> Use a formula to determine which cells to format
• Edit the Rule Description: Format values where this formula is true: =AND($B2<$C2,$I2="Yes")
• Format… [Number, Font, Border, Fill]
• OK >> OK

 

[timfritsch]

This worked for me. Assumption is that "Product" is in cell A1.

Highlight the range A2:I3. In the conditional formatting dialog box, select Use a formula to determine..., and the formula is =AND($B2<$C2,$I2="Yes")=TRUE


Tim