Conditional Formatting

[rguliuzza]

Hi Community Members,

I have a bit of a dilemma which, most likely, has a simple solution. Based on the table below, I want to run a conditional formatting rule that will add item 1 & 2 for each month and if that is greater then the yearly / 12, I want to either have red for > or green for <. I can do it if I create a rule for each column; however, I was wondering if there is one I can do across multiple columns, for the 12 months?

Thank you.

	Jan	Feb	Mar
Item 1	8000	4000	7500
Item 2	3000	4500	11000
Yearly	120000

<tbody>
</tbody>

 

[etaf]

assuming the rows and columns are as laid out - so Jan = B1

and so Year = B4

=B$2+B$3>$B$4/12 = Red
=B$2+B$3<$B$4/12 = green

then the applies to will define the area to colour
and so apply to all columns

Excel Workbook
	A	B	C	D	E	F	G	H
1	Jan	Feb	Mar
2	Item 1	8000	4000	7500		B$2+B$3
3	Item 2	3000	4500	11000		B$2+B$3>$B$6/12 = Red
4
5
6	Yearly	120000
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2	1. / Formula is =B$2+B$3>$B$6/12	Abc
B2	2. / Formula is =B$2+B$3<$B$6/12	Abc

 

[rguliuzza]

Hi Wayne,

Thank you for that, I will try it and see what happens.

Best regard,
Rick

 

[etaf]

your welcome, post back if issues