Hi, I have a sheet (sheet 1) with a range (F3:F100) with figures either in red font or green. I need to sum these figures according to their font colour either red or green and place the results in two cells in a different sheet, eg sheet 2, A12 for sum total of those in red, and A13 for the sum total of those in green. Please could someone help me with the coding on this as I am a VBA newbie. Thank you.
Bookmarks