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
44 Replies
EXCEL DO NOT SHOW GRAPH MAP CHART
Mark 777 in Excel on
47 Replies
Split data from one column into two columns
Jonni Anderson in Excel on
6 Replies
align decimals in a column
Jonni Anderson in Excel on
15 Replies
blink a cell
Lorenzo Kim in Excel on
12 Replies
Missing Excel 2013 worksheet tabs
Mike Hill in Excel on
7 Replies