+ Reply to Thread
Results 1 to 2 of 2

Formula/Conditional Formatting error questions

  1. #1
    Registered User
    Join Date
    11-29-2023
    Location
    USA
    MS-Off Ver
    Excel
    Posts
    10

    Lightbulb Formula/Conditional Formatting error questions

    G11, G12, and G13 I would like to correlate with D12's values.

    D12 (0-14) turn G11 Green with conditional format and text prompt via formula.
    D12 (15-29) Turn G13 Orange with conditional format and text prompt via formula.
    {example: =IF(AND(30<=D12),"We have reached criteria for RED level interventions. Please implement RED level interventions.","") }
    D12 (30+) Turn G15 Red with conditional format and text prompt via formula.

    D12 is changing colors accordingly, but G11,13,15 are not and I cannot seem to figure out why.

    Also, H18:21 (comments). I would like to dates to automatically display today's date when anything is typed into these rows, showing no date if empty. I cannot get these to change accordingly. Example (=IF(H18<>"",IF(CG18="",TODAY(),H18),""))

    I found this version within a forum online. I've gotten it to work on a separate sheet, but not on this. I am also unaware of where/why the "C" is included in the "CG18".
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Formula/Conditional Formatting error questions

    It seems that your workbook was set to manual calculations, just change it.

    Go to 'Files' then 'Options' then 'Formulas', set to Automatic.
    Attached Files Attached Files
    Last edited by DJunqueira; 01-03-2024 at 06:03 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional formatting: two questions
    By terrypin in forum Excel General
    Replies: 14
    Last Post: 01-02-2018, 07:48 AM
  2. Conditional Formatting Questions
    By gianloplo21 in forum Excel General
    Replies: 1
    Last Post: 03-06-2017, 05:16 AM
  3. Conditional Formatting Questions
    By swalsh^s96 in forum Excel General
    Replies: 3
    Last Post: 12-04-2015, 04:43 PM
  4. Conditional formatting and graphing questions
    By pjennewe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-02-2013, 08:14 PM
  5. Replies: 0
    Last Post: 06-05-2010, 11:46 PM
  6. Conditional formatting questions.
    By lordfa9 in forum Excel General
    Replies: 11
    Last Post: 06-27-2007, 09:32 PM
  7. Conditional Formatting Questions
    By danika in forum Excel General
    Replies: 5
    Last Post: 09-21-2005, 01:05 PM

Tags for this Thread

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