conditional formatting

Hii..

Can any one please help with conditional formatting based on adjacent 3 columns ???

Eg

if any of Cells in column A1 B1 C1 is filled red then Cell D1 must turn red.
if any of Cells in column A1 B1 C1 is not filled red & is filled yellow then Cell D1 must turn yellow.
if any of Cells in column A1 B1 C1 is not filled red nor filled yellow then Cell D1 must turn green.

Please HELP !!!

THANKS

Thanks Mr Ford for your quick reply.

Yes it is applied manually. could you please share the VBA code ?

It is a risky approach identifying red or yellow, if it is always the same colour then it is doable, however if you get shades of red, it becomes very hit and miss. We don't know what red or yellow you use!


Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Not the complete answer, but hopefully on the way, you can finish off with conditional Formats

Dear davsth,

Thanks for the feedback.

i have received the attachment but the cells in the final output column are not yet filled in that color which is in either RED, YELLOW or GREEN.

Pls help

Thanks

Thanks so much all of you have helped me .

You all are GREAT !!!

THANKS