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
Bookmarks