Home

Conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-467141%22%20slang%3D%22en-US%22%3EConditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-467141%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20format%20a%20row%20of%20data%20so%20that%20it%20greys%20out%20if%20I%20enter%20certain%20text%20into%20another%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%20If%20I%20type%20a%20letter%20in%20column%20H%20then%20all%20the%20columns%20(A-H%20or%20A-G%20if%20it's%20easier)%20in%20that%20row%20grey%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EApologies%20if%20this%20has%20already%20been%20asked%20and%20thanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBarry%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-467141%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EConditional%20Formatting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-467451%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-467451%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F322801%22%20target%3D%22_blank%22%3E%40BEphgrave%3C%2FA%3E%26nbsp%3B%2C%20use%20a%20rule%20formula%20like%20%3D%24H1%3D%3CYOUR%20text%3D%22%22%3E%20and%20apply%20it%20to%20your%20entire%20range.%20(or%20%24H%23%20if%20your%20range%20starts%20from%20%23%20row).%20It's%20important%20to%20acre%20about%20absolute%20and%20relative%20references%20in%20your%20formula.%3C%2FYOUR%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
BEphgrave
Occasional Visitor

Hi

I am trying to format a row of data so that it greys out if I enter certain text into another cell.

 

Example: If I type a letter in column H then all the columns (A-H or A-G if it's easier) in that row grey out.

 

Apologies if this has already been asked and thanks in advance.

 

Barry 

1 Reply

@BEphgrave , use a rule formula like =$H1=<your text> and apply it to your entire range. (or $H# if your range starts from # row). It's important to acre about absolute and relative references in your formula.

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies