Conditional Format cells if greater than or less than zero

The purpose of this spread sheet is to calculate the revenue of a campground.

In cell F36 = (calculated revenue)
F37 = (actual revenue - counted cash & checks)
F38 = (the difference, positive or negative (F36 - F37)
E38 = "short"
D38 = "over"
C38 = "Discrepancy"

Now the question:

I would like cell C38, cell D38 and F38 to be colored black if F38 is positive or zero.
I would like cell C38, cell E38 and F38 to be colored red if F38 is negative.

Is this over the moon or is it possible?

Thanks,

Mel

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about a proper thread title and adjust accordingly...
• Changed for you this time, but please pick an appropriate title next time…Thanks.

Hi Mel,

Try some conditional formatting...

Conditional Formatting

• Highlight applicable range >> $C$38:$D$38,$F$38
• Home Tab >> Styles >> Conditional Formatting
• New Rule >> Use a formula to determine which cells to format
• Edit the Rule Description: Format values where this formula is true: =AND(ISNUMBER($F$38),$F$38>=0)
• Format… [Number, Font, Border, Fill] >> Black
• OK >> OK

Add a new rule, but this time the formula use:
=AND(ISNUMBER($F$38),$F$38<0) >> and format Red

It would help if I knew what part of the directions in post #2 you get stuck with?

Hi Mel,

The formulas do not go in a cell, they go in conditional formatting.

You first highlight the range, so in your case, C38 and D38, then hold down the ctrl key and click on F38.

After the cells and highlighted, you go to the ribbon starting with the home tab and follow the rest of the directions above.

Searching youtube you can find many tutorials on using conditional formatting.

Hi Mel,

Unless you changed the font colors on your spreadsheet, you really do not need condition 1 (black) and the default color is black.

Anyway, in this example I added two rules, one for the black and one for the red.

Hi Mel,

Glad to hear you finally have it working according to your requirements. Thanks for the feedback.