condiational formatting

Hello, I am trying to Highlight multiple cells based on a specific cell. If cell K32 = True, I want cells B2:G239 highlighted in one color and if K32 = False, then no change. I have tried the following with no luck: Thanks in advance for any assistance!

Hi there. I'm using Excel for Mac 16.53, with an Office 365 subscription. I'd like to create a macro for repeated use to apply borders to my spreadsheets whenever there's a change in value in column B. But I want to do this via Conditional Formatting, as the values in the spreadsheets can...

Hi guys! I have a column that I need to color with conditional formatting based on two different criteria. I am using the following formula in the conditional formatting pain and it does work: =AND(AC2="Yes", AK2=INDIRECT("Partners!B6")) The issue is I need the range of Partners!B6:B not just...

I have 3 cells that I am looking at: Contact Name Name Word Count Name Fix John John Doe 3 John Doe Bear Bear Joe 3 Bear Joe What I need is to run Conditional Formatting formula to highlight the CONTACT NAME column if the number in the NAME WORD COUNT column is equal to 3 and if the...

Hello, i'm trying to use the conditional formatting icon set check mark, and X to format column A based based on what is in Column B Column A is STATUS Column B is formatted as TIME I would like to use conditional formatting in Column A (status). If there is a time entered in Column B then a...

Hello! I am having trouble wording this but the idea is pretty simple. Table A: Table B: (located on a different sheet) I would like Row 2 in Table A to be highlighted because it does not match either row in Table B. I will need it to be able to compare certain cells because in my actual...

#Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Sheet 1 many Spaces in there , So i Need "invoice Number list" on Sheet 2 (Auto Generated) how to possible get data as a list format, NOTE: SHEET 1 : *** So many Space in there*** SHEET 2...

Trying to Highlight the max number of consecutive positive numbers. with the help of the following formula, can able to get the max number of consecutive positive numbers. but when tried to be applied as a conditional formula - no luck...

Hi all, I'm trying to format these percentages with rounding based on the value of each cell. If the percentage value is less than 10% round to = #.#% If the percentage value is less than 0.1% round to = #.##% If the percentage value is less than 0.01% round to = #.###% Hopefully the example...

Hi, I have below data & need to highlight the cells which have duplicate value in "A" as well as "B"&"C" column. pl suggest. Location "A" Material "B" Qty"C" Remarks A1-02-01 AAA 9 formula/condition should highlight this duplicate b4-03-09 XYZ 31 b4-04-01 ABC 42 A1-02-01 DDD 28...

I am trying to do away with column B on my spreadsheet by using conditional formatting to highlight column C. Currently I visually check the dates in column B to be prior to today to determine which budgets need to be actioned. I though I had the conditional formula right but nothing happens...

I am trying to highlight column B based off of values in column A. If A has the word parts in it, then I want B to change. I Googled it and seen several examples, I just can't find a way that works for me...

Hello Experts, I need help in highlight the cells of "Doc Reference ID" by referring "GST%". Requirement is - IF "GST %" column is not equal to 18 OR 28 then respective cell of "Doc Reference ID" should highlight in RED Doc. Reference ID GST % 202100004415 18 202100004437 28...

I have company IDs listed out and repeated in column A, and in column M, I have email domains. Some email domains may be repeated but some companies may have multiple domains for a single company ID. I need to identify the company IDs in column A that have multiple email domains in column M. In...

Hi All, Say I have a restaurant and need certain staff on different tasks each night. We try to make it so that each member of staff perform each job at some point in the week. I want to avoid one member of staff being in the pair that for example washes pots 3 days a week when everyone...

Hello, I am new to this so please excuse my ignroance... this is my first post... I just have a question I want to create a macro that cuts data from a certain range in one sheet and then pastes that data into another sheet if one condition is met. So I have attached this spreadsheet as an...

Query : How Set Different Number to Different color Highlight (like a same number Group Show in same color) Number match perfect & Smart..........pleased Solve it Conditional...