What formula can i use

QuestionEdit

If any of the first 3 cells in a row has a value as mentioned in the sheet the final cell should automatically change into green color. How can I do this with out macros?

AnswerEdit

Jugal,

1. Go to cell G6 and choose Home > Conditional Formatting > New Rule: 2. Enter the following formula into the box "Format values where this formula is true: =IF(OR(D6="1.0.41",E6="1.0.42",F6="1.0.43"),TRUE,FALSE) Select the color you want below ("Preview") 3. Copy down cell G6 up to G17.

Kind