View Full Version : [SOLVED:] using conditional format to change font if column has a number greater than or equal
selfteaching
05-17-2019, 10:31 AM
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
Fluff
05-18-2019, 06:10 AM
How about
=COUNTIF(C153:C500,">=6000")
selfteaching
05-19-2019, 08:22 AM
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
Fluff
05-19-2019, 09:18 AM
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
selfteaching
05-19-2019, 01:07 PM
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
Fluff
05-19-2019, 01:18 PM
The formula should work in Conditional formatting.
What version of Xl are you running?
Fluff
05-19-2019, 01:51 PM
Forgot to mention, can you supply a copy of your workbook?
selfteaching
05-19-2019, 02:23 PM
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
Fluff
05-20-2019, 04:57 AM
Glad you got it sorted & thanks for the feedback
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.