View Single Post
 
Old 12-08-2018, 01:05 PM
AC PORTA VIA
Guest
 
Posts: n/a
Default Cell text color vs cell background color

Hi to all
I have one column with a lot of rows with DIFFERENT background COLOR but text color is same for all which makes some of rows hard to read
(some rows background color and text color is almost the same)
Need vba code to change text color based on cell background color to be able to read text
different colors in rows are not conditional formatted
Thanks
EDIT BELOW
attached file shows different colors in column I-These are actually duplicates values
FYI-Colors are made by macro inserted in column M
i hope i made it clear enough to understand
Attached Files
File Type: xlsx TEST.xlsx (13.5 KB, 16 views)

Last edited by AC PORTA VIA; 12-08-2018 at 04:46 PM.
Reply With Quote