•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting based on a different cell's value
Our take
Conditional formatting can significantly enhance your tracking sheet by visually representing the status of your tasks. To achieve the desired effect of clearing the formatting of the required delivery cell when the status cell is set to "complete," you'll want to set up a conditional formatting rule based on the status cell’s value. Instead of using an "IF" formula, consider applying a custom formula in your conditional formatting settings that references the status cell.
I'm fumbling my way through conditional formatting on a tracking sheet I'm creating. I have the status and required delivery formatting the way I want, but now I'm running into an issue where I want it to clear the formatting of the required delivery cell once the status cell is set to "complete" like the bottom row. The status cells are drop down menu if that makes a difference.
I've tried playing around with "IF" formulas, but nothing seems to be happy with what I'm trying. Any thoughts?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional Formatting with another cell?Hi everyone! I'm trying to create a condition where depending on the value of two cells, it will change the fill of one of them. For example, If Cell A is < 10% AND Cell B is X, then Cell A will be green. If it is > 10% and Cell B is X, then Cell A is red. How would I go about doing this? submitted by /u/Educational-Bass-413 [link] [comments]
- Conditional formatting based on a range of text in 2nd sheetHey! I have a two sheet workbook. First sheet has column A: list of order numbers that should be highlighted based on status and column B: status. the status text comes from a list in the second sheet. all possible statuses are listed from A1:A10 on the second sheet, but there might select colors per status (like from A1:A3 and A10 would all need the same color) Right now I have as a formula: =$B1='Sheet2!A1 and that works, but trying to use a range doesn't work =$B1='Sheet2!$A1:$A$5 I'm certain I'm overlooking a basic issue, but my googling skills are failing me 😞 submitted by /u/jaegerjockey [link] [comments]
- Conditional formatting date help neededI've been trying to use conditional formatting to help automate my work spreadsheet and the date formulas truly escape me. I feel like TODAY is a meany who likes to stick their tongue out at you and point for being stupid XD. This is a spreadsheet with a schedule on it. I am trying to get it to automatically grey out the text when the date passes so I can sort and filter by color and always keep the next upcoming appointment slot be top of the list, while still keeping the data in this sheet because another sheet refers to it via XLOOKUP. https://preview.redd.it/z1jqata8w6xg1.png?width=364&format=png&auto=webp&s=d49f71c8de80c402de1af923fc87e3371d606cc8 Here's the formula I'm using =AND($B$2<TODAY(), $D$2<> "") Column D is client names, for privacy purposes I didn't copy that. They end at D11, if it matters. I'm not sure why excel is treating the dates in May as if they are less than today, when they're not. Does anyone have any ideas? submitted by /u/tashykat [link] [comments]
Tagged with
#financial modeling with spreadsheets#rows.com#Excel compatibility#row zero#Excel alternatives for data analysis#Excel alternatives#cloud-based spreadsheet applications#conditional formatting#tracking sheet#status cell#required delivery#clear formatting#dropdown menu#IF formulas#complete#formatting issue#data validation#cell value#Excel#automated updates