Results 1 to 9 of 9

Conditional Formatting keeps wanting me to type apostrophes

Threaded View

  1. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Conditional Formatting keeps wanting me to type apostrophes

    IF(logical_test, value_if_true, [value_if_false])

    logical_test (required) - The condition you want to test.
    value_if_true (required) - The value that you want returned if the result of logical_test is TRUE.
    value_if_false (optional) - The value that you want returned if the result of logical_test is FALSE.

    your logical_test is : ISNUMBER(06) = always TRUE
    but you forgot about value_if_true and value_if_false so function IF() doesn't know what to show.

    edit:
    but if you want to check number or not number enough to use =ISNUMBER(A1) (cell address change suitable). Result will be TRUE/FALSE so it will enough for CF
    Last edited by sandy666; 03-17-2016 at 11:29 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 3 Colour Scale Conditional Formatting by Formula Type
    By swong1709 in forum Excel General
    Replies: 5
    Last Post: 03-05-2015, 07:14 AM
  2. Wanting to create conditional formatting that is not Cell related.
    By deliveryboy83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2014, 02:46 PM
  3. Replies: 6
    Last Post: 07-02-2013, 10:29 AM
  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