Bold-facing a cell from another

Jon15n · May 25th, 2002, 01:39 PM

HI! Bear with me here-
What would the formula be if I want to have a cell automatically become bold-faced, if another cell has a number equal to or higher than 3?
Thanks so much!

Jack in the UK · May 25th, 2002, 01:43 PM

I would suggest adding conditional formatting to the cells that you which to make bold if greater than 3 to

Then as you edit the range they will react

Remember to con for mat all the range to bold, not just the top cell as is often done.

Jack in the UK · May 25th, 2002, 02:09 PM

Jon15n posted

Hey, I need a 'main' cell to become bold, corresponding to an 'other' cell that has a value equal to or greater than 3.
So, what I mean is, when this 'other' cell has the number 3 in it, the 'main' cell will become bold.
They are two seperate cells. Get it?
Please help me!
Thank you!

Jack in the UK · May 25th, 2002, 02:09 PM

Aladin Akyurek posted

Got it, except which cell is the main cell and which cell is the other cell .

Lets say that A1 is the main cell and B1 the other cell.

Activate A1.
Activate Format|Conditional Formatting.
Select Formula Is for Condition 1.
Enter as formula:

=$B$1>=3

Activate Format.
Select bold from the Font tab.
Activate OK, OK.

May 25th, 2002, 01:43 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	I would suggest adding conditional formatting to the cells that you which to make bold if greater than 3 to Then as you edit the range they will react Remember to con for mat all the range to bold, not just the top cell as is often done. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 25th, 2002, 02:09 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Jon15n posted Hey, I need a 'main' cell to become bold, corresponding to an 'other' cell that has a value equal to or greater than 3. So, what I mean is, when this 'other' cell has the number 3 in it, the 'main' cell will become bold. They are two seperate cells. Get it? Please help me! Thank you! __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 25th, 2002, 02:09 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Aladin Akyurek posted Got it, except which cell is the main cell and which cell is the other cell . Lets say that A1 is the main cell and B1 the other cell. Activate A1. Activate Format\|Conditional Formatting. Select Formula Is for Condition 1. Enter as formula: =$B$1>=3 Activate Format. Select bold from the Font tab. Activate OK, OK. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 25th, 2002, 01:39 PM	#1
Jon15n New Member Join Date: May 2002 Posts: 5	HI! Bear with me here- What would the formula be if I want to have a cell automatically become bold-faced, if another cell has a number equal to or higher than 3? Thanks so much!