Conditional Formatting ?

Flamesteel

New Member
Joined
Mar 29, 2008
Messages
11
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
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

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:

Watch MrExcel Video

Forum statistics

Threads
1,122,518
Messages
5,596,630
Members
414,082
Latest member
sasmita

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