Conditional Format Similar to Conditional Format in Excel spreadsheet

[stephicohu]

Hi guys!

I have another question to ask about the conditional format. I want to use the same or similar function in the excel application. I tried using the macro option to get some help but it didn't work well. I have been coding for about a month and learning on google and a microsoft press book. So my knowledge in VBA is limited. Here is what I want to do:

What I am doing?

I want to make a spreadsheet that has been previously format for conditional formatting so when it comes time to used that spreadsheet I just plug in numbers in the cell and the conditional format works. I only need two conditions one for red which means not being met and green for being met. The color is just like the function in excel, with red fill with dark red text and green fill with dark green text. I know how to do the colors by going to find the numbers that correspond to the color. What I don't know is how to set up the conditions for the cells. Any advice you have on this matter?

 

[Micron]

Not sure I follow. Why not just manually set format conditions on a sheet and use that as a template? Not seeing a connection between what you describe and vba.