IF statement to color a cell

rjk4774 · May 23rd, 2002, 10:44 AM

I am comparing two cells, B10 and B11. If B10-B11>=.01 I want cell B11 to turn red if the statement is false I want B11 to have no pattern. Anyhelp would be appreciated. Thanks Everyone.

Mark O'Brien · May 23rd, 2002, 10:46 AM

Have a look at conditional formatting. Format|Conditional Formatting...

HTH

rjk4774 · May 23rd, 2002, 11:15 AM

If I use the conditional formating I can change the color of B12, but I can't figure out how to change the color of B11 since B11 is part of the formula for the conditional format

lenze · May 23rd, 2002, 11:18 AM

Formula is =B10-B11>=0.01

Brian from Maui · May 23rd, 2002, 11:18 AM

Do the conditional format in B11

Go to Format/Conditional formatting/Formula is =b10-b11>=.01 click format/pattern OK OK

rjk4774 · May 23rd, 2002, 12:09 PM

Brian, I think I did exactly what you said. If I go through the steps in a cell other than b11 it works fine. However, when I use the conditional formatting in b11 nothing happens.

Brian from Maui · May 23rd, 2002, 12:13 PM

What values are in B10 and B11?

Yogi Anand · May 23rd, 2002, 12:23 PM

Quote:

On 2002-05-23 11:09, rjk4774 wrote:
Brian, I think I did exactly what you said. If I go through the steps in a cell other than b11 it works fine. However, when I use the conditional formatting in b11 nothing happens.

Hi rjk4774:
Brian's formula should work. Please post the CONDITIONAL FORMAT formula you used for cell B11. Also did you choose the color 'red' as Pattern?

rjk4774 · May 23rd, 2002, 12:24 PM

Brian, I think I got it figured out. I had parenthesis around my cells in the equation and for some reeason it did not like it. I took out the parenthesis and it seems to work. Thank you and everyone else for the help.

May 23rd, 2002, 10:46 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Have a look at conditional formatting. Format\|Conditional Formatting... HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

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

May 23rd, 2002, 10:44 AM	#1
rjk4774 New Member Join Date: May 2002 Location: Montana Posts: 4	I am comparing two cells, B10 and B11. If B10-B11>=.01 I want cell B11 to turn red if the statement is false I want B11 to have no pattern. Anyhelp would be appreciated. Thanks Everyone.

May 23rd, 2002, 11:15 AM	#3
rjk4774 New Member Join Date: May 2002 Location: Montana Posts: 4	If I use the conditional formating I can change the color of B12, but I can't figure out how to change the color of B11 since B11 is part of the formula for the conditional format

May 23rd, 2002, 11:18 AM	#4
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Formula is =B10-B11>=0.01

May 23rd, 2002, 11:18 AM	#5
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Do the conditional format in B11 Go to Format/Conditional formatting/Formula is =b10-b11>=.01 click format/pattern OK OK

May 23rd, 2002, 12:09 PM	#6
rjk4774 New Member Join Date: May 2002 Location: Montana Posts: 4	Brian, I think I did exactly what you said. If I go through the steps in a cell other than b11 it works fine. However, when I use the conditional formatting in b11 nothing happens.

May 23rd, 2002, 12:13 PM	#7
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	What values are in B10 and B11?

May 23rd, 2002, 12:24 PM	#9
rjk4774 New Member Join Date: May 2002 Location: Montana Posts: 4	Brian, I think I got it figured out. I had parenthesis around my cells in the equation and for some reeason it did not like it. I took out the parenthesis and it seems to work. Thank you and everyone else for the help.