.In the list box at the top of the dialog box, click the Use a Formula to Determine which Cells to Format option.This selection evaluates values based on a formula you specify. If a particular value evaluates to TRUE, the conditional formatting is applied to that cell.In the formula input box, enter the formula shown with this step.Note that you are simply comparing your target cell (E3) with the value in the comparison cell ($B$3). As with standard formulas, you need to ensure that you use absolute references so that each value in your range is compared to the appropriate comparison cell.Click the Format button.This opens the Format Cells dialog box, where you have a full set of options for formatting the font, border, and fill for your target cell.
![]() ![]()
In the example below, we have five lookup values where we want to check if they exist in our larger data set. All I have to do to perform this check is to right the MATCH formula for each of my numbers. Lookup Value: (select the relevant lookup value) Lookup Array: (select the data set array) Match Type: 0 (tells Excel to look for an exact match). Excel conditional formatting rule to highlight cells based on another cell's value. =$A2cells or rows if a value in column A is less than the. 2 columns for duplicate values - i.e. Find and highlight values that exist in both. I am using excel 2007 for Mac so no VBA option. Thanks for your help.
![]()
After you have completed choosing your formatting options, click the OK button to confirm your changes and return to the New Formatting Rule dialog box.Back in the New Formatting Rule dialog box, click the OK button to confirm your formatting rule.If you need to edit your conditional formatting rule, simply place your cursor in any of the data cells within your formatted range and then go to the Home tab and select Conditional Formatting→Manage Rules. This opens the Conditional Formatting Rules Manager dialog box. Click the rule you want to edit and then click the Edit Rule button.Here are some.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |