Results 1 to 9 of 9

conditional formatting error

Threaded View

sumesh56 conditional formatting error 02-14-2022, 10:45 PM
Gregb11 Re: conditional formatting... 02-14-2022, 11:19 PM
sumesh56 Re: conditional formatting... 02-15-2022, 11:15 PM
protonLeah Re: conditional formatting... 02-14-2022, 11:22 PM
sumesh56 Re: conditional formatting... 02-15-2022, 11:18 PM
Gregb11 Re: conditional formatting... 02-16-2022, 08:00 AM
sumesh56 Re: conditional formatting... 02-16-2022, 09:46 PM
Gregb11 Re: conditional formatting... 02-16-2022, 10:02 PM
sumesh56 Re: conditional formatting... 02-16-2022, 10:42 PM
  1. #1
    Forum Contributor
    Join Date
    02-28-2012
    Location
    india
    MS-Off Ver
    Excel 2019
    Posts
    545

    conditional formatting error

    In my worksheet i want to compare two values given in col s and col p. I want to see that if given value in col s is greater than that of given in col P it may be shown as green else in RED . I applied conditional formatting.

    selected cell S6. conditional formatting- greater than- then selected P6- color green selected- then again did the same steps with Less than and selected color as RED. I copied down with format painter. i got results. But in some cells the result is showing calculation errors. I have put a yellow formatted cell in col-U against each error cell .is there any other(better) way to get the desired result? Kinldy help me in sorting out the issue. kindly go thru the attached.thanks
    Last edited by sumesh56; 02-14-2022 at 10:48 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting Error - Need Help
    By Gootz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2020, 03:57 PM
  2. Conditional Formatting Error
    By Dnyan in forum Excel General
    Replies: 2
    Last Post: 08-23-2017, 12:10 PM
  3. [SOLVED] Conditional Formatting error
    By rojashan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-04-2014, 12:31 AM
  4. Conditional Formatting - Run Time Error '13' Type Mismatch Error
    By ksp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2011, 07:37 PM
  5. [SOLVED] Conditional Formatting error
    By Nikki in forum Excel General
    Replies: 1
    Last Post: 03-10-2006, 07:35 AM
  6. [SOLVED] conditional formatting for Error
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  7. Conditional Formatting Error
    By ddate in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-05-2005, 04:06 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