Conditional formatting again!

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

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!

Aladin Akyurek · May 25th, 2002, 02:04 PM

Quote:

On 2002-05-25 12:58, Jon15n wrote:
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!

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.

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

Pease stay on the same feed it will confuse people as people will answer both and we will end up in a mess.

Link feed..

http://www.mrexcel.com/board/viewtop...9485&forum=2&1

If you don’t agree or understand my post please post and feel free it ask me or other to explain, i really don’t mind, please don’t open new feeds it gets silly

I’m not telling you off, just trying to get you sorted. Ill transfer the add on over to the other question to help ..

Aladin Akyurek · May 25th, 2002, 02:08 PM

Quote:

On 2002-05-25 13:06, Jack in the UK wrote:
Pease stay on the same feed it will confuse people as people will answer both and we will end up in a mess.

Link feed..

http://www.mrexcel.com/board/viewtop...9485&forum=2&1

If you don’t agree or understand my post please post and feel free it ask me or other to explain, i really don’t mind, please don’t open new feeds it gets silly

I’m not telling you off, just trying to get you sorted. Ill transfer the add on over to the other question to help ..

I agree.

sen_edp · May 25th, 2002, 03:07 PM

I agree with Jack and Aladin

take a look at this too

http://www.cpearson.com/excel/newposte.htm

May 25th, 2002, 02:06 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Pease stay on the same feed it will confuse people as people will answer both and we will end up in a mess. Link feed.. http://www.mrexcel.com/board/viewtop...9485&forum=2&1 If you don’t agree or understand my post please post and feel free it ask me or other to explain, i really don’t mind, please don’t open new feeds it gets silly I’m not telling you off, just trying to get you sorted. Ill transfer the add on over to the other question to help .. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 25th, 2002, 03:07 PM	#5
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	I agree with Jack and Aladin take a look at this too http://www.cpearson.com/excel/newposte.htm __________________ Best Regards Andreas

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

May 25th, 2002, 01:58 PM	#1
Jon15n New Member Join Date: May 2002 Posts: 5	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!