Cell or Word/number bold by value/%?

[jonjon_01]

Is there a way to color a cell or bold a letter/number on a cell by the value of a cell, automatically?

Example: The date on A15, C15, F15, etc have values over 7.5. Going through the cells, for anything that is 7.5 or higher is bolded or the cell's background color is changed?

If A15 is 7.5%, is there a way to highlight the rest of the cell in row A upto A15?

Thanks again.

 

[Norie]

You could use conditional formatting.

For the first condition you could just select A15,C15 etc, goto Format>Conditional formatting..., select Cell Value Is, greater than and enter 7.5.

I'm not sure what you mean by the 2nd condition, can you explain it further.

 

[jonjon_01]

Hi Norie,

Let me correct myself. I'm ditzing out.

Ok say Column M has values from M2-M54. Some of the rows have a value or % of 7.5 or higher (as an example).

So, M5, M11, M15 has 7.5 or higher value. Is there a way to have these rows text values placed in bold or background cell colored changed, automatically, just for that row...

 

[Norie]

Is this what you mean?

If any row in column M is >7.5, then format the entire row?

If it is then try this.

1 Select the rows you want to format.

2 Goto Format>Conditional Formatting...

3 Select Formula Is from the dropdown.

4 Enter this formula =$M2>7.5.

5 Hit Format... and format as desired.

By the way if the column actually contains percentages you might need to change 7.5 to 0.075, Excel stores percentages as fractions of 1 eg 1=100%, 7.5=750%