Cell or Word/number bold by value/%?

jonjon_01

New Member
Joined
Oct 31, 2005
Messages
17
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.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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.
 
Upvote 0
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...
 
Upvote 0
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%
 
Upvote 0

Forum statistics

Threads
1,217,750
Messages
6,138,407
Members
450,134
Latest member
TYoung24

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top