Results 1 to 3 of 3

Thread: Conditional Formating

  1. #1

    Question Conditional Formating



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Everyone


    Im having problems with the result I want with my formula.


    The formula works but Im unable to copy to other cells


    =IF(($I$4<>""),$I$4<0.5) Then highlight in yellow.


    For example, for CELL "I5" I want the formula to show =IF(($I$5<>""),$I$5<0.5) without having to go in on every single cell and fix it.

    When I merge conditional formatting, it copies exactly the same formula. Each formula should affect its own cell.

    See attachment


    Thanks in advance
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Conditional formatting.png 
Views:	13 
Size:	24.7 KB 
ID:	4103  

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    751
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Did you try $I4 instead of $I$4 ?

  3. #3
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Could you please describe what your formula is supposed to check for?

    PS "IF" is assumed in CF, so it's not necessary

Tags for this Thread

Posting Permissions

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