Conditional Formatting or maybe If/Then

[jimbofoxman]

I understand Conditional Formatting on reports in MS Access.......but in Excel it throws me. Plus, I don't use Excel nearly as much as Access. I can do basic formulas, no problem. Getting fancy starts causing problems.

I have a cell (T50) that is calculating the difference between cells R16 and Q50.

Basically what I am looking to do is that if the difference is greater than .05 (positive or negative) that a Message with say red background and bold white text pops up in cell U50 saying "Check blah blah blah". My other thought was also to do the same formatting (red background and bold white text) for the calculation cell T50.

Basically if the difference is greater than +/- 0.05 we need to go back and look at all the receipts for the day, make sure something wasn't missed and need a way to remind people to do that.

Any suggestions for a Excel newbie are greatly appreciated!

Thanks!

 

[Special-K99]

You need two things:
1. To set U50 to a message or blank depeding on T50
2. To set the condtional formatting of cell U50 based on the value of T50

1. in U50
=IF(ABS(T50)>0.05,"Check blah blah blah","")

2. Select U50

Conditional Formatting
New Rule
Use a formula to determine...

=ABS(T50)>0.05

Format as red background with white text.

 

[jimbofoxman]

You need two things:
1. To set U50 to a message or blank depeding on T50
2. To set the condtional formatting of cell U50 based on the value of T50

1. in U50
=IF(ABS(T50)>0.05,"Check blah blah blah","")

2. Select U50

Conditional Formatting
New Rule
Use a formula to determine...

=ABS(T50)>0.05

Format as red background with white text.

Special-K99

Thanks for the assist! ABS is what I needed! I had tried another way, but failed. PERFECT!

Thanks again!