Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    387
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Conditional formating a formula cell

    i want a conditional format, within a cell that has a formula.

    if the Conditional Format cell is less than or greater than 5% then a red circle should appear in the cell.

    I am attaching a worksheet sample (with out cell formatting).

    Column D would have the icon desired.

    Thank you
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi

    The icon sets for conditional formatting don't allow you to do exactly what you want.
    The closest would be something like:
    1. Show a red dot if the value is 5% (or more) below the TOTAL avg $ per receipt
    2. Show a green dot if the value is 5% (or more) greater than the TOTAL avg $ per receipt
    3. Show a yellow dot if the value is within 5% of the TOTAL avg $ per receipt

    See attached file.

    However, if you really really wanted just a red dot as per your request, then this would have to be done via VBA.
    It would be complicated, but achieveable.

    zeddy
    Attached Files Attached Files

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    387
    Thanks
    3
    Thanked 0 Times in 0 Posts
    This definitely works however, I was looking for a solution to include the RED DOT ICON within the formula cell by having a conditional formula within the formula cells (column D only). I showed the formulas in column E for demonstration purposes.

    Is this doable with Conditional Formating.

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi

    Have another look at the attached file.
    I took out column E formulas. Didn't use them before either.
    So you are left with conditional formatting, using a conditional formula, in column D only, with icon dot set.

    It would be possible to show red dots only as per your original request, but this would not be done by conditional formatting.
    I could also do this without VBA.

    zeddy
    Attached Files Attached Files

Posting Permissions

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