Conditional Formatting Question

[jcl408]

I want to have a conditional formatting setup whereby if the date in H5 (and so on) is later than the date in G5, it is red, and if it is on or before that date it is green. Could anyone help me out with a formula or setup for this?

 

[VoG]

Try like this

Excel Workbook
	G	H
5	21/07/2011	20/07/2011
6	21/07/2011	23/07/2011
Sheet8

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H5	1. / Formula is =H5<=G5	Abc
H5	2. / Formula is =H5>G5	Abc

 

[jcl408]

Try like this

Excel Workbook
	G	H
5	21/07/2011	20/07/2011
6	21/07/2011	23/07/2011
Sheet8

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H5	1. / Formula is =H5<=G5	Abc
H5	2. / Formula is =H5>G5	Abc

Awesome! Thank you. is there any way to have it so if the cell is "N/A" it doesnt change color

 

[VoG]

That shouldn't change the color

Excel Workbook
	G	H
5	21/07/2011	20/07/2011
6	21/07/2011	23/07/2011
7	22/07/2011	#N/A
Sheet8

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H5	1. / Formula is =H5<=G5	Abc
H5	2. / Formula is =H5>G5	Abc

 

[jcl408]

I had an IF(ISERROR()) in there changing what it said away from #N/A. Removed it and it doesnt change color anymore. Thanks again