What formula can i use

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 10:03 PM GMT

Question

Excel screenshot

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?

Answer

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

Advertisement

©2024 eLuminary LLC. All rights reserved.