BOLD or change color with formula?

D

donnajay

New Member
Joined
Jul 30, 2009
Messages
36
First off, I know nothing about Conditional Formatting...

Is it possible to have a cell either change color or change font color or go bold when a formula is true?

Example: A persons goal is 200. On jan 1 they only have 180, on jan 2 they have 250. I would like to have the 250 be represented that they are "over" goal. I would use the over/under wording but I still need to see the number in the box....

Thanks in advance, your past helps have been a godsend! :biggrin:
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Sort by date Sort by votes
You could use the Formula option in Conditional Formatting. =A1>=200

You can substitute a cell reference for 200 if you have it.

Otherwise, can you post the formula you're using?
 
Last edited:
Upvote 0
Select the cell and choose Format|Conditional Formatting from the menu. For Condition 1 choose Cell value is greater than 200, choose a format and click OK twice.
 
Upvote 0
Andrew, when I select a cell there is no option for conditional formatting.

Smitty, If I choose A1 doesnt that make the whole sheet use that formula?

I am not using any formula now.

I have 6 columns across with each persons name in it.
I have the days of the month down the left side.

In the bottom cell, say B29 and across, I have the goal number for each person.

I thank you for your quick responses. I think I will just manually change the font color if the goal is over.

Have a great day!:cool:
 
Upvote 0
You would select the range between the names and row 29, then in CF-->Formula--> =B2>=B$29
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Conditional Formatting - Change text color based on calculation
Replies
3
Views
612
jfeagle
J
I
  • Question
converting multiple dates to months then change color in a separate cell
Replies
2
Views
273
Inquiring_Minds
I
M
  • Solved
Change red color letters by bold red color letters with underline
Replies
5
Views
181
MocLinh
M
D
  • Solved
Formulas for conditional formatting
Replies
1
Views
523
Joe4
Joe4
V
  • Solved
conditional formatting formula for two-leg match tie-breaker
2 3
Replies
25
Views
964
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,214,942
Messages
6,122,366
Members
449,080
Latest member
Armadillos

Share this page

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