+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting, Colours conditions

  1. #1
    Registered User
    Join Date
    12-19-2017
    Location
    Portugal
    MS-Off Ver
    Microsoft office 2010
    Posts
    25

    Conditional Formatting, Colours conditions

    Hi,

    I got many cell with "CERTO" and "ERRADO", I know how to perform conditional formating the columns, so when it shows "CERTO" it colours red.

    The spet I don't know how to do, is now performing the conditional in the rows, when i got a cell green, if there is any "Errado" i want to turn them as red.

    I will attach my excel file with the input and the desired output.

    1) SEARCH "CERTO" FOR COLUMNS, AND TURN "CERTO" INTO GREEN
    2) SEARH FOR ROWS, IN THE ROW THERE IS A GREEN "CERTO" TURN ALL "ERRADO" IN THAT SAME ROW "RED"


    Thanks,
    Tiago
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Conditional Formatting, Colours conditions

    Perhaps
    =AND(C4="ERRADO",COUNTIF($C4:$E4,"CERTO"))

+ 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. Replies: 6
    Last Post: 01-24-2017, 04:38 PM
  2. Replies: 3
    Last Post: 06-08-2016, 06:27 AM
  3. [SOLVED] Conditional Formatting - Colours
    By caziscarol in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-24-2014, 05:59 PM
  4. how to count the colours used in conditional formatting
    By adhrua@yahoo.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-08-2013, 08:49 AM
  5. Macro for formatting fonts and cell colours - not Conditional Formatting
    By Kayaness in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-07-2011, 03:46 AM
  6. Conditional Formatting different colours in cells
    By Georgefluff in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-02-2008, 07:04 AM
  7. [SOLVED] Conditional Formatting Counting Colours
    By DMc2004 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2005, 10:06 AM

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