8 808living New Member Jan 17, 2011 #1 i'm an excel beginner and would like to know how to apply conditional formatting to my spreadsheet. i would like certain rows to be highlighted if the following conditions are not satisfied: for example, C2 + D2 is less than B2. any help would be greatly appreciated.
i'm an excel beginner and would like to know how to apply conditional formatting to my spreadsheet. i would like certain rows to be highlighted if the following conditions are not satisfied: for example, C2 + D2 is less than B2. any help would be greatly appreciated.
Hui Excel Ninja Staff member Jan 17, 2011 #2 Select the Rows Conditional Formatting New Rule Use a Formula Enter the formula =$C$2+$D$2<$B$2 Select Format Apply
Select the Rows Conditional Formatting New Rule Use a Formula Enter the formula =$C$2+$D$2<$B$2 Select Format Apply
8 808living New Member Jan 17, 2011 #4 hui, one more question... if i wanted to apply the formatting to the entire spreadsheet, how do i go about doing that?
hui, one more question... if i wanted to apply the formatting to the entire spreadsheet, how do i go about doing that?
Hui Excel Ninja Staff member Jan 17, 2011 #5 Select all the cells before applying the CF To select all the cells click the small area to the Upper Left of A1
Select all the cells before applying the CF To select all the cells click the small area to the Upper Left of A1
