Conditional Formatting || Entire row based on two cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2809115%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20%7C%7C%20Entire%20row%20based%20on%20two%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2809115%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20trying%20to%20do%20conditional%20formatting%20for%20A2%20to%20K2%2C%20based%20on%20H2%20%26amp%3B%20K2%2C%20but%20it%20is%20not%20working.%3C%2FP%3E%3CP%3EThe%20idea%20is%20whenever%20I%20am%20giving%20the%20actual%20dates%20in%20the%20respective%20cells%2C%20it%20should%20give%20conditional%20formatting%20like%2C%20when%20I%20enter%20actual%20start%20dates%2C%20it%20should%20give%20%22yellow%22%20color%2C%26nbsp%3Bwhen%20I%20enter%20actual%20finish%20dates%2C%20it%20should%20give%20%22green%22%20color.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2809115%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2809157%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20%7C%7C%20Entire%20row%20based%20on%20two%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2809157%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1157567%22%20target%3D%22_blank%22%3E%40arunrj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version.%3C%2FP%3E%0A%3CP%3EYou%20can%20view%20the%20rules%20in%20Conditional%20Formatting%20%26gt%3B%20Manage%20Rules.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2817088%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20%7C%7C%20Entire%20row%20based%20on%20two%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2817088%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3A%26nbsp%3BThanks%2C%20This%20is%20working%20in%20this%20file%2C%20but%20when%20I%20tried%20to%20do%20same%20with%20another%20file%20but%20it%20is%20not%20working%2C%20is%20there%20any%20condition%20for%20this%20for%20not%20working%2C%20if%20I%20am%20still%20having%20those%20empty%20cells%20to%20give%20input.%20but%20some%20reference%20of%20it%20is%20given%20for%20calculation%20in%20some%20other%20cells%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I was trying to do conditional formatting for A2 to K2, based on H2 & K2, but it is not working.

The idea is whenever I am giving the actual dates in the respective cells, it should give conditional formatting like, when I enter actual start dates, it should give "yellow" color, when I enter actual finish dates, it should give "green" color.

 

Please help.

3 Replies

@arunrj 

See the attached version.

You can view the rules in Conditional Formatting > Manage Rules.

@Hans Vogelaar : Thanks, This is working in this file, but when I tried to do same with another file but it is not working, is there any condition for this for not working, if I am still having those empty cells to give input. but some reference of it is given for calculation in some other cells ?

 

@arunrj 

Please check data range to which rule is applied, first cell in it which used in formula and using of absolute/relative references. Usually issues are about that.