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
and had it change the format to redCode:=C153:C500=>6000
When I test it, it doesn’t work
What am I missing?
mike
How about
=COUNTIF(C153:C500,">=6000")
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
Not sure why you would get that, as it works for me
Excel 2013 32 bit
Sheet: Sheet1
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
The formula should work in Conditional formatting.
What version of Xl are you running?
Forgot to mention, can you supply a copy of your workbook?
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. :banghead:
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
Glad you got it sorted & thanks for the feedback