If the font in column C is red then make the corresponding cells in column D also red. Also sum all cells with red font
If the font in column C is red then make the corresponding cells in column D also red. Also sum all cells with red font
Last edited by Pepe Le Mokko; 02-22-2020 at 11:19 AM.
Are the fonts in column C red from manual formatting or from conditional formatting?
If conditional formatting, what is the formatting rule?
If not conditional formatting, then this requires VBA, and more information will be necessary.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Cash 7 4 weeks £7.00
Cash 9 4 weeks £6.00
Cash 8 4 weeks £6.50
Cash 16 4 weeks £6.00
bank 27 4 weeks £20.00
bank 35 4 weeks £7.00
bank 17 4 weeks £8.50
bank 1804 weeks £9.00
I have a table similar to the one above.
I then want to highlight the bank payments with a diferent color to cash payments so the are easy to see.
As I highlight "bank" with a different color, I would like the system to automatically highlight the corresponding
amounts ie "£7.00" in the same color as the color of bank. I then want to be able to soum all the bank payments and
all the non bank payments
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks