conditional formatting

[cornepiek]

hi all

i need some help with conditional formatting

i have two columns, F and G.

i need to have any value in column G greater the the same cell in column f marked red

and any value in column g less than the same cell in column f to be marked green.

please help

 

[VoG]

Try like this

Excel Workbook
	F	G
1	1	2
2	2	1
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G1	1. / Formula is =G1	Abc
G1	2. / Formula is =G1>F1	Abc

 

[cornepiek]

i tried this formula, but for this i need to manually enter the formula for each cell.

i am working with a growing data sheet so the amount of rows that needs to be formatted will change every day.

is there a way i can format the entire column like this, or use a macro to format only the populated cells in the column?

 

[VoG]

You can select the whole of column G (or as much of it as you wish) and apply the CF formulas given. Excel will adjust the formulas automatically for rows below row 1.