identify found cell by changing color

[ClearConcept]

I'm using =LARGE(D1:D3000,1) to find the largest number in the column. I would like to identify the cell that contains that number by changing at least the color. The cells in column d have =c xx + e xx, so I'm assuming I need to revise the formula to include an if condition, but not sure how to change the attributes of the cell, e.g., color or bold or both

[ChemistB]

Select your range (D1:D3000) and Go to Conditional Formatting and "Using Formula"

Please Login or Register  to view this content.

and format accordingly. The appropriate cell will be formatted/colored. Does this work for you?

[ClearConcept]

I selected the range, then using conditional formatting - I selected "the cell value" "is equal to" and pointed to the cell that contains the formula =large(d1:d3000,1) and IT WORKED! When I tried "using formula" all the cells changed color - You were a huge help! Thank you!