SOLVED

Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1520964%22%20slang%3D%22en-US%22%3EConditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1520964%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20you%20change%20the%20whole%20row%20colour%20based%20on%20the%20formatting%20of%20a%20particular%20cell%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFormatting%20cell%20colour%20is%20being%20changed%2C%20according%20to%20the%20status%20of%20that%20cell%2C%20but%20we%20need%20the%20whole%20row%20to%26nbsp%3Bchange%20colour%2C%20rather%20than%20just%20the%20cell%2C%20is%20this%20possible%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1520964%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521026%22%20slang%3D%22de-DE%22%3ESubject%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521026%22%20slang%3D%22de-DE%22%3ESelect%20the%20entire%20area%20you%20want.%20%3CBR%20%2F%3E%20Go%20to%20Start%20in%20Excel%20%3CBR%20%2F%3E%20Styles%20Conditional%20formatting%20New%20rule%20Use%20the%20formula%20to%20determine%20the%20cells%20to%20be%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20formatted%20format%20values%20that%20is%20true%20%3CBR%20%2F%3E%20for%20this%20formula%3A%20Enter%20the%20following%20formula%20%3CBR%20%2F%3E%20in%20the%20bar%20%2F%20input%20field%20below%3A%20%3CBR%20%2F%3E%20%3D%20A%20'%202%20%3D%20%22B%22%20%3CBR%20%2F%3E%20-%20A%20'%202%20%3D%20is%20the%20cell%20and%20%22B%22%20is%20the%20column%20where%20formatting%20conditional%20is%20triggered.%20%3CBR%20%2F%3E%20How%20to%20set%20the%20condition%20for%20color%20marking.%20%3CBR%20%2F%3E%20But%20it%20would%20be%20an%20advantage%20if%20you%20could%20upload%20a%20file%20where%20you%20could%20better%20help%20from%20there%20...%20Thousand%20words%20a%20picture%20%3A-).%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521043%22%20slang%3D%22en-US%22%3EBetreff%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521043%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EThank%20you%2C%20I%20have%20attached%20below%20a%20screenshot%2C%20you%20can%20see%20%E2%80%98Status%E2%80%99%20is%20where%20the%20conditional%20formatting%20is%20set%20up%2C%20and%20this%20works%20great%2C%20however%20they%20would%20like%20the%20whole%20row%20%E2%80%98C-K%E2%80%99%20to%20be%20formatted%2C%20to%20change%20colour%20as%20the%20status%20is%20changed%2C%20not%20just%20the%20cell%20%E2%80%98K%E2%80%99%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20Regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-ERR%3AREF-NOT-FOUND-%40Nikolino%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521592%22%20slang%3D%22de-DE%22%3ESubject%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521592%22%20slang%3D%22de-DE%22%3EI%20am%20happy%20if%20it%20is%20good%20for%20you%20and%20you%20can%20work%20with%20it.%20%3CBR%20%2F%3E%20It%20makes%20just%20as%20much%20joy%20for%20someone%20who%20gives%20help%20and%20for%20someone%20who%20gets%20help%20...%20think%20both%20are%20happy%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%20...%20with%20a%20like%20or%20correct%20answer%20I%20would%20be%20even%20happier%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%20...%20even%20if%20I%20don't%20challenge%20my%20luck%20like%20that%20should%20%3A-).%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Have%20a%20good%20day%2C%20with%20love%2C%20joy%20and%20health.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521764%22%20slang%3D%22en-US%22%3EBetreff%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521764%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F535985%22%20target%3D%22_blank%22%3E%40SadieOakmont%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20do%20so%2C%20select%20the%20range%20C11%3AK23%20(as%20per%20your%20screenshot)%20and%20make%20a%20New%20Rule%20for%20conditional%20formatting%20using%20the%20formula%20given%20below%20and%20set%20the%20format%20as%20per%20your%20choice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3D%24K11%3D%22Progress%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EWhile%20the%20range%20is%20still%20selected%2C%20make%20similar%20rules%20for%20other%20status%20and%20set%20the%20different%20format%20as%20per%20the%20Status.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Can you change the whole row colour based on the formatting of a particular cell?

 

Formatting cell colour is being changed, according to the status of that cell, but we need the whole row to change colour, rather than just the cell, is this possible?  

4 Replies
Select the entire area you want.
Go to Start in Excel
Styles
Conditional formatting
New rule
Use the formula to determine the cells to be formatted
Format values that is true for this formula:
Enter the following formula in the bar / input field below:
= $ A $ 2 = "B"
$ A $ 2 = is the cell and "B" is the column where conditional formatting is triggered.
How to set the condition for color marking.
But it would be an advantage if you could upload a file where you could better help from there ... Thousand words a picture :-).

Nikolino
I know I don't know anything (Socrates)
 

Thank you, I have attached below a screenshot, you can see ‘Status’ is where the conditional formatting is set up, and this works great, however they would like the whole row ‘C-K’ to be formatted, to change colour as the status is changed, not just the cell ‘K’

 

 

Kind Regards

 

@Nikolino 

I am happy if it is good for you and you can work with it.
It makes just as much joy for someone who gives help and for someone who gets help ... think both are happy ... with a like and or correct answer I would be even happier ... even if I don't challenge my luck like that should :-).

Have a good day, with love, joy and health.

Nikolino
I know I don't know anything (Socrates)
Best Response confirmed by SadieOakmont (New Contributor)
Solution

@SadieOakmont 

To do so, select the range C11:K23 (as per your screenshot) and make a New Rule for conditional formatting using the formula given below and set the format as per your choice.

 

=$K11="Progress"

While the range is still selected, make similar rules for other status and set the different format as per the Status.