Color function for a worksheet

[j21willy]

I am working on a sheet right now for net and gross skins for golf. I currently have the formulas for the sheet to find the net and low and was wondering if anybody could give me some help on one thing. If you take a look at the sheet I would like to have an automatic color change for the skin that appears. Example would be hole 1 in gross skins. I would like the low score (3) to automatically change colors in the sheet so it is easy to point out. In net skins look at hole 2. I would like the low net score (2) to automatically change colors.

Thanks for your help

[protonLeah]

For example:
1. Select the range D4:D19
2. Menu: Format>Conditional Formatting:
3. Condition 1:
Formula is:

Please Login or Register  to view this content.

* Select your desired format.