Hi there,

I have attached a sample spreadsheet to show you what I mean by this.

Formatting Test.xlsx

If cell B is less than or equal to cell C, for both of them to be filled green.

If Cell B is more than cell C then not to format anything.

Also, is there a quick way to copy this formula as I have other sheets which use the same information (but don't use cells B & C)?

Many thanks,
Gary