Results 1 to 5 of 5

Conditional Formatting - How to use formula type???

Threaded View

eeps24 Conditional Formatting - How... 08-23-2017, 04:29 PM
FDibbins Re: Conditional Formatting -... 08-24-2017, 01:18 AM
AliGW Re: Conditional Formatting -... 08-24-2017, 01:25 AM
eeps24 Re: Conditional Formatting -... 08-24-2017, 08:18 AM
AliGW Re: Conditional Formatting -... 08-24-2017, 08:27 AM
  1. #1
    Forum Contributor
    Join Date
    06-28-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    192

    Question Conditional Formatting - How to use formula type???

    Every month I have to manually modify this table (which is time-consuming).

    If "RVUs YTD" is greater than the "RVU target", I want a green checkmark and if its less then I want a red X. I have already achieved this as you can see in my screen shot, but, I have to modify these each month manually (these values increase each month) .

    In my second screen shot, if I select "type" and make it "formula", how can I achieve to do this automatically?

    What do I type in the value box so that if B4>D4 it will make it green automatically?

    Thank you

    *I have attached the spread sheet.

    cap1.PNG

    Capture.PNG
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. conditional formatting based on type of text
    By asmi in forum Excel General
    Replies: 2
    Last Post: 06-10-2016, 10:48 AM
  2. 3 Colour Scale Conditional Formatting by Formula Type
    By swong1709 in forum Excel General
    Replies: 5
    Last Post: 03-05-2015, 07:14 AM
  3. Replies: 3
    Last Post: 08-04-2012, 07:22 PM
  4. Choose the type of conditional formatting
    By Beginner Level in forum Excel General
    Replies: 3
    Last Post: 05-04-2012, 05:12 AM
  5. Change font type in Conditional Formatting
    By Kyndsberg in forum Excel General
    Replies: 1
    Last Post: 01-23-2006, 05:20 PM
  6. Conditional Formatting type of operation
    By titushanke in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-13-2005, 03:25 AM
  7. Conditional formatting type question...
    By mightyhef in forum Excel General
    Replies: 0
    Last Post: 02-09-2005, 08:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1