Conditional Formatting ?

Flamesteel

New Member
Joined
Mar 29, 2008
Messages
13
Hello all and thanks to all the Excel Forum members for helping others.

My question is concerning using conditional formatting for cells.

I have my workbook for our golf league and would like to fill cells when the players score on each hole is over "NET PAR". When the scores are net par and under, the cells will remain clear.

So the conditions used are, the "Players Handicap", "Hole Handicap"
Par Score of Hole, and Players Gross Score.

Thanks, Club Rat
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Simon Lloyd

Well-known Member
Joined
Sep 10, 2006
Messages
756
click the cell that you want to format once (lets say its B1), go to conditional formatting and from the dropdown choose Formula Is, then type =A1 < B1 then choose a format (patterns>red), click ok and then copy the cell down.

Now if the value in B1 is greater than the value in A1 the cell will turn red, you can add up to 3 conditions in excel 2003 and nore in 2007 onwards.
had to use quotes because of html parsing here???
 
Last edited:
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,147
Messages
5,835,669
Members
430,373
Latest member
swartzfeger

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