VBA Code to Include Font Color

[Cremorneguy]

Hi,

I am currently using the following VBA in my spreadsheet:

Please Login or Register  to view this content.

However the code is not working on the conditionally formatted cells. I assume its because these particular cells have the letter "X" in them. Or it might not work because the cells are conditionally formatted? All i know is that the above VBA works only on cells that i manually color with RGB 128,128,128 and not cells when they are conditionally formatted to RGB 128,128,128 using the format based on a formula. Can someone please help me so that the above VBA works on both manually and conditionally formatted cells.

Many thanks

[jewelsharma]

see this - Conditional Formatting Colors
hope it helps!

[Cremorneguy]

Hi, thanks for that but i have no idea how to write a VBA, someone else gave me the above VBA so i have no idea how to include what i want.