Forum Discussion
Finding and highlight certain values
I have multiple columns of data, and I want to highlight any cell that is 89 or above. How can I do this w/o filtering each column?
Select the entire range.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'greater than or equal to' from the second drop down.
Enter 89 in the box next to it.
Click Format...
Activate the Fill tab.
Select a color.
Click OK, then click OK again.