Home

Conditional formattings problems with Mac 2011

%3CLINGO-SUB%20id%3D%22lingo-sub-775693%22%20slang%3D%22en-US%22%3EConditional%20formattings%20problems%20with%20Mac%202011%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775693%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20have%20a%20spreadsheet%20for%20keeping%20track%20of%20my%20freelance%20work.%20I%20used%20simple%20formatting%20to%20color%20the%20cells%20that%20contain%20each%20client%20name%20(Classic%20%26gt%3B%20Format%20only%20cells%20that%20contain%20%26gt%3B%20Specific%20text).%20I%20realized%20it%20might%20also%20be%20more%20readable%20to%20also%20color%20the%20cells%20where%20I've%20entered%20the%20fee%20for%20each%20project%20to%20match%20the%20client%20cell%20colors.%20Originally%20the%20%22applies%20to%22%20box%20for%20each%20formula%20only%20contains%20the%20cells%20of%20the%20%22client%22%20column%2C%20like%20%24A%243%3A%24A%24201.%20I%20tried%20searching%20for%20how%20to%20do%20this%20and%20haven't%20seen%20anything%20similar.%20So%20I%20just%20added%20the%20%22fee%22%20column%20to%20the%20%22applies%20to%22%20box%20like%20this%3A%20%24A%243%3A%24A%24201%2C%24H%243%3A%24H%24201.%20I%20genuinely%20don't%20know%20if%20that's%20possible%2C%20but%20there%20were%20no%20errors%20and%20selection%20lines%20now%20appear%20around%20both%20A%20and%20H%20columns.%20But%20the%20color%20formatting%20is%20still%20only%20applying%20to%20A%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20I%20hadn't%20actually%20seen%20this%20option%20was%20possible%2C%20I%20also%20tried%20doing%20the%20whole%20row%20(not%20my%20preference)%20with%20the%20%22use%20formula%20to%20determine%20which%20cells%20to%20format%22%20and%20%24A3%3D%22Client%20name%22%20which%20is%20what%20I've%20found%20online.%20Nothing%20happened%2C%20and%20the%20original%20formatting%20disappeared.%20Curious%2C%20I%20tried%20the%20more%20simple%20formula%20for%20alternating%20row%20colors%20MOD(ROW()%2C2)%3D0%2C%20and%20again%20nothing%20happened.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20opened%20a%20blank%20workbook%2C%20and%20tried%20the%20formula%20for%20alternating%20row%20colors.%20Nothing...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20a%20designer%20and%20spreadsheets%20are%20definitely%20not%20my%20thing!%20Can%20you%20please%20tell%20me%20what%20I'm%20doing%20wrong%3F%20Thank%20you%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-775693%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
nchuang
Occasional Visitor

Hello, I have a spreadsheet for keeping track of my freelance work. I used simple formatting to color the cells that contain each client name (Classic > Format only cells that contain > Specific text). I realized it might also be more readable to also color the cells where I've entered the fee for each project to match the client cell colors. Originally the "applies to" box for each formula only contains the cells of the "client" column, like $A$3:$A$201. I tried searching for how to do this and haven't seen anything similar. So I just added the "fee" column to the "applies to" box like this: $A$3:$A$201,$H$3:$H$201. I genuinely don't know if that's possible, but there were no errors and selection lines now appear around both A and H columns. But the color formatting is still only applying to A column.

 

Since I hadn't actually seen this option was possible, I also tried doing the whole row (not my preference) with the "use formula to determine which cells to format" and $A3="Client name" which is what I've found online. Nothing happened, and the original formatting disappeared. Curious, I tried the more simple formula for alternating row colors MOD(ROW(),2)=0, and again nothing happened.

 

I opened a blank workbook, and tried the formula for alternating row colors. Nothing...

 

I'm a designer and spreadsheets are definitely not my thing! Can you please tell me what I'm doing wrong? Thank you so much!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies