MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 273|Reply: 5

How to change font color if one in a series exceeds a limit.

[Copy link]

1

Topics

3

Posts

11

Integral

Member

Rank: 2

Integral
11
Post on 9-14-2016 18:34:05 | All posts |Read mode
If I have seven numbers in column A1:A7 and want them to all change font color if any one of them exceeds 100, how would I set a conditional format to accomplish this?
Thanks, Bill




Reply

Props Report

1

Topics

3

Posts

11

Integral

Member

Rank: 2

Integral
11
 Author| Post on 9-14-2016 19:41:50 | All posts



Does anyone know what the proper forum would be for this question?
Reply Support Opposition

Props Report

1

Topics

3

Posts

11

Integral

Member

Rank: 2

Integral
11
 Author| Post on 12-18-2016 16:23:42 | All posts



Does anyone know what the proper forum would be for this question?




Reply Support Opposition

Props Report

0

Topics

5

Posts

12

Integral

Member

Rank: 2

Integral
12
Post on 12-18-2016 16:46:41 | All posts
Reply Support Opposition

Props Report

0

Topics

5

Posts

12

Integral

Member

Rank: 2

Integral
12
Post on 12-18-2016 18:42:26 | All posts
Reply Support Opposition

Props Report

14

Topics

699

Posts

1588

Integral

King

Rank: 6Rank: 6

Integral
1588
Post on 12-18-2016 19:41:59 | All posts



gregg11,
This is not a cross post since it was posted here 8 months prior to the one you cite.


On PC's it's:
=A1100
applied to A1:A7
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-24-2017 21:20 , Processed in 0.227202 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!