Control Excel cell color using a function

Hello.

Wondering if cell color can be controlled using a function instead of a macro.  Specifically what I need is to turn the cell fill color yellow when a data entry error is made by a user.  Here is my existing function which is in Cell C3:

=IF(SUM(B3-A3)>0,"Error","")

In addition to displaying "Error", which it already does, I want to modify the function to turn cell C3 yellow when an Error is made (i.e. when the value in B3 is greater than the value of A3)

Thank you
dbfromnewjerseyAsked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
You do that by selecting "Conditional Formatting" from the "Styles" group
  1. Click "New Rule"
  2. Select "Format only cells that contain"
  3. Then in "Format only cells with" choose "Cell value" and "equal to" and in the box to the right, type "Error" (without the quotes)
  4. Then click the "Format" button, select the "Fill" tab and choose yellow
  5. Click OK twice
0
 
Martin LissOlder than dirtCommented:
Add Conditional Formatting in C3 that looks like this.

Cursor_and_Conditional_Formatting_Ru.jpg
0
 
dbfromnewjerseyAuthor Commented:
Thanks
0
 
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.