I just cant get conditional format to work!

steallan

Active Member
Joined
Oct 20, 2004
Messages
304
I know this is lame but can someone help

All I want to do is set two conditional formats in cell N10. T

he first colours the cell yellow if the value in it is greater than in cell B10

The second colours the cell red if the value in it is less than in cell B10

I then need to copy these two conditions down the rest of column N so that for cell N11 it is comparing it to B11, N12 to B12 etc

Im dumb and cant do it!

Help!
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

1.Select cell N10 and then extend this selection down as far as you need ie to cell N1000 etc
2. Go Format>Conditional Formatting
3. Change to Formula Is
4. In the formula box type: =$N10>$B10 and format as Yellow
5. Add another conditiona and use formula: =$N10<$B10 and format as Red
6. Click OK

That should work - post back if it doesn't.

Richard

Edit: amended the formula to actually work! Thanks OaD!
 

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

Select N10 to N (something)

select FORMAT --> CONDITIONAL FORMATTING

change cell value is to FOMRULA IS and enter

=N10<B10

add another CONDITION

change cell value is to FOMRULA IS and enter

=N10>B10

format as required
 

steallan

Active Member
Joined
Oct 20, 2004
Messages
304
Crisp!

It wasn't working for me coz i tried =$N$10>$B$10 and =N10>B10 so wasn't copying down properly

god **** i hate conditional formatting, but love Mr Excel

Thanks for the help
 

Forum statistics

Threads
1,140,916
Messages
5,703,161
Members
421,278
Latest member
16cwilliams

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
Top