Consulting

Results 1 to 9 of 9

Thread: using conditional format to change font if column has a number greater than or equal

  1. #1

    using conditional format to change font if column has a number greater than or equal

    Hi

    Iím trying to have the font in cell K165 change from black to red if any number that gets entered in C153:C500 is greater than or equal to 6000
    I went to K165 and put this in conditional format
    =C153:C500=>6000
    and had it change the format to red
    When I test it, it doesnít work

    What am I missing?

    mike

  2. #2
    How about
    =COUNTIF(C153:C500,">=6000")

  3. #3
    Hi Fluff,
    I tried your formula first with the " and then with out "
    with ", no formula was recognized
    without ", I got a message that there were too few arguments.
    C153:C500 is formatted with general numbers.

    mike

  4. #4
    Not sure why you would get that, as it works for me

    Excel 2013 32 bit
    C
    D
    153
    5995
    =COUNTIF(C153:C500,">=6000")
    154
    5996
    22
    155
    5997
    156
    5998
    157
    5999
    158
    6000
    159
    6001
    160
    6002
    161
    6003
    162
    6004
    163
    6005
    164
    6006
    165
    6007
    166
    6008
    167
    6009
    168
    6010
    169
    6011
    170
    6012
    171
    6013
    172
    6014
    173
    6015
    174
    6016
    175
    6017
    176
    6018
    177
    6019
    178
    6020
    179
    6021
    Sheet: Sheet1

  5. #5
    I want it to go into conditional format. . K165 already has 6000 When the condition is met, I want the font to change to red

    mike

  6. #6
    The formula should work in Conditional formatting.
    What version of Xl are you running?

  7. #7
    Forgot to mention, can you supply a copy of your workbook?

  8. #8
    Fluff,
    I was deleting any personal info on the spreed sheet, when I decided to try again.
    Funny, It worked when I made sure the last " was in the formula.

    I also found that I can copy and past into the conditional format box.
    I'm using Windows 10 64 bit and Windows Office 365

    Thank you for your patients.

    I record my millage on my lease truck and wanted to keep track when the oil change is due. Now a cell with the last oil change millage will turn red when its time for another one.

    mike

  9. #9
    Glad you got it sorted & thanks for the feedback

Posting Permissions

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