Conditional Formating across Multiple Cells

RichardWatson

New Member
Joined
Aug 5, 2011
Messages
11
Hi Guys,

My 2nd question of the day! ;)

I want to use Conditional Formating to change the font colour to either red or green depending on a certain value in corresponding cells.

for example if A3 is greater than A1 the font should be Green (or red if lesser than) I wan tthis to be the same through B3 and H3.

Is there a simple way of doing this or do I have to make the individual formating for each cell?

Thanks again!
 
I have just done it the way you have suggest too and all of the cells remain with a red coloured font!!
Could you provide a small set of sample data and identify what cells it is in?

What version of Excel are you using?
 
Upvote 0

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
200 cells shouldn't be a problem. Just select them all before applying the CF as if you are just applying it for the first one. Or just apply the first cell and use the Format Painter to apply to the other 199 or whatever.



What 'sum' are you talking about? If you told us what your sample data was, where it is, what your CF rules are and what you are trying to achieve we might be able to advise why it is not acting as you expect. Without seeing what you have done, it's hard to diagnose. ;)
thanks for all fo your assistance Peter, I am very grateful.

OK what I have is..
A1:A200 a number
B1:B200 a number
C1:C200 an IF equasion of A&B 1:200
D1:D200 an IF equasion from the result of C1:c200

I want D1:D200 to have either red or green font deneding on the result of the IF equasion (greater than or lesser than)

make sense?
When I do the CF in D1 alone it works fine, when I multi select it doesnt.
So when I am making the rule in CF I have 2 rules one for greater than A1 and one for lesser than A1.

When selecting the multi cells in the rule I am instructing the multi cells by typing it like this A1:A200

In my mind that should work, but it doesnt the font on them all returns as red.
 
Upvote 0
OK what I have is..
A1:A200 a number
B1:B200 a number
C1:C200 an IF equasion of A&B 1:200
D1:D200 an IF equasion from the result of C1:c200

I want D1:D200 to have either red or green font deneding on the result of the IF equasion (greater than or lesser than)

make sense?
When I do the CF in D1 alone it works fine, when I multi select it doesnt.
So when I am making the rule in CF I have 2 rules one for greater than A1 and one for lesser than A1.

When selecting the multi cells in the rule I am instructing the multi cells by typing it like this A1:A200

In my mind that should work, but it doesnt the font on them all returns as red.
Not very clear - you didn't say what the formula is in D1 nor what your CF formula(s) are.

However, If you are just wanting to compare D1 to A1, D2 to A2 etc do this..

1. Select D1:D200

2. Remove any existinf CF.

3. Apply the CF exactly as shown below (no A1:A200 or anything like that)

Note that I have just hidden columns B:C since if we are just comparing D to A they are not relevant.

If this does not colour the correct cells green, PLEASE provide say 5 rows of actual data and tell us exactly what formulas you have in C1 and D1 as well as exacly what CF formulas you have for cell D1.

Excel Workbook
AD
125
2810
394
42420
568
CF
Cells with Conditional Formatting
CellConditionCell FormatStop If True
D11. / Formula is =D1>A1Abc
 
Upvote 0

Forum statistics

Threads
1,224,585
Messages
6,179,700
Members
452,938
Latest member
babeneker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top