Check out some problems solved by our top Experts or click here to post your own problem for free!

I need a conditional formatting with a formula between 2 dates. If A1 contains the date July 8, 2018 & A2 contains the value of A1-7 (date) - how do I apply this to a conditional format to have A2 turn red if true

Solved by B. S. in 26 mins

Is there an actual function that changes cell colour rather than Conditional Formatting? It wouldn't work in this situation. I basically have an IF statement and I want the TRUE result to be the colour of the cell changing. Ive tried setting it to "1", then setting a rule where all "1" become that colour, but nothing happens. I've tried it with and without the quotations.

Solved by F. J. in 28 mins

just trying to use Conditional Formatting to compare items listed in column F to items listed in column G (1 for 1) to highlight/find the ones that that are duplicate. For example, I just want to know if F2 and G2 are a match, NOT if F2 has ANY matches in the entire column of G...

Solved by F. Y. in 25 mins

I'm working on an Excel spreadsheet with 7 columns. If there is a DATE in column 5, I'm wanting the whole line formatted with strikethrough. How do I do this under conditional formatting? Or, is there another way?

Solved by T. H. in 26 mins

Column A contains name of participants.
Column B contains the binary info of whether the participant won. If won, then 1, if lost, 0.
So, if I assign 1 to column B(meaning the participant won), I want the cell in column A&B to be highlighted in green.
Used Conditional formatting. But unable to assign this rule to all participants at once. Instead, I have to conditional format every participant.

Solved by X. H. in 10 mins

I have a volume cell & a price cell & i need a conditional formatting to highlight the price cell in red, if there is a value in the volume cell & no value in the price cell

Solved by D. D. in 20 mins

I need a formula in conditional formatting to shade cell O4 blue if cell F4 contains part of "District Active Support Member"

Solved by G. U. in 20 mins

Hi,
I am using Conditional Formatting in Excel. I am trying to compare text in one column to text in another column, but the text in the one of the columns is included within other text.
So, for example, a cell in column A includes the phrase: "I use Excel everyday" and a cell in column B includes the phrase "use Excel". I am trying to figure out whether the phrase "use Excel" in column B appears in column A, even though it is included within other text.
My entire spreadsheet is like this. Column B is a fragment of text in Column A.
If I click on Conditional Formatting, New Rule, Format Only Cells That Contain, Specific Text...

Solved by O. Q. in 25 mins

I have a question about Conditional Formatting.
=IF('Sheet1'!A1="X",IF('Sheet1'!B1="Y", TRUE, FALSE),FALSE) the set the cell background to red.
I would like to make it so that if Sheet1'!B1="Z" I set the back to blue.
How can I achieve this.

Solved by B. F. in 39 mins