Home

Excel Conditional Formatting

Highlighted
Colleen Bishop
Occasional Visitor

Excel Conditional Formatting

Hi,

I have a column of data that I want to format to be bold when it is greater than 5000. But, in it I have numbers that are <1000 and written this way as well as numbers that include 0.010 I or 0.010 U. If they contain the letters or less than symbol I still want them to be bold but if they aren't I don't. How would I go about doing this?

1 Reply

Re: Excel Conditional Formatting

Hi, If all the values are in the same column you'll have to set-up multiple conditional formatting rules to capture all cases. You can do this by selecting the data column which needs to be formatted, going to Conditional Formatting and then New Rule. Use 'Format only cells that contain' option and then use cell value for the >5000 criteria and specific text for the others.

 

I've attached a screenshot of how the formulas would look like once set. Let me know if you're running into any issues.

Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
57 Replies
Security Warning: Automatic update of links has been disabled.
Mark Adams in Excel on
6 Replies
EXCEL DO NOT SHOW GRAPH MAP CHART
Mark 777 in Excel on
47 Replies
Running Comparison
Robert V Giancarlo in Excel on
11 Replies
Excel Compare Data
Arnold Lopez in Excel on
12 Replies