PDA

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