Jul 30 2019 06:29 AM
Jul 30 2019 06:29 AM
I need all cells in a row to highlight a certain color if the data in one cell contains a specific word.
What I specifically want is for an entire row to turn grey if the status cell contains the word "SHIPPED." I know how to make that specific cell highlight the color I want, but not the entire row of the sheet.
Thank you for your help!
Nov 23 2022 07:29 AM
That's better to discuss with sample file. You may try something like
Nov 24 2022 12:10 AM
Thanks for the prompt response! I wanted to share my file, but can't figure out how to attach it :(
Nov 24 2022 12:33 AM
If you cannot attach a sample file, you can make it available through OneDrive, Google Drive, Dropbox or similar
Dec 14 2022 07:20 AM
Is there a way to change the entire row color if the text is the same in one cell, then to change the a different entire row(s) when the text changes to another word to a different random color?
I want to have an entire spread sheet become color coded based on a program name in column F. I don’t care what the colors are.
Dec 14 2022 07:37 AM
You'd have to create a different rule for each word.
For example, if you want to color a row if column F contains Excel:
Dec 29 2022 10:09 AM
Jan 03 2023 03:44 AM
Not sure I understood the logic. For such sample
formula for conditional formatting rule could be
=( ROW($C3) > ( XMATCH("start", $B$3:$B$12) + ROW($B$3) - 1 )) * ( ROW($C3) < ( XMATCH("total", $B$3:$B$12) + ROW($B$3) -1 ))
Jan 03 2023 08:40 AM
Yes, that's perfect. I didn't think of setting a 'start' value cell for the upper limit, I was just trying to highlight everything above 'total,' but I can make it work with your suggestion. Many thanks!
Jan 09 2023 05:10 PM - edited Jan 09 2023 05:12 PM
Help please :)
I have this data below:
When the status in column D is updated, I would like the back ground from C17:E20 to fill that light purple colour.
Any assistance would be greatly appreciated.
Jan 10 2023 12:18 PM
"updated" means changing from any one value to any other one. Afraid that doesn't work. You may assign rules for predefined set of values. One rule for one value.
Feb 25 2023 02:20 AM
Apr 03 2023 07:31 AM
Apr 03 2023 09:31 AM
@Sergei Baklan I'm seeking to sum dollar values in one column where the conditional formatting rule of "cell that contains "insurance"" in another column. Was first using the conditional formatting of highlighting cells that contain "insurance" then trying to sum another column in that same row. my hangup is that the cell is not an equal to rather 'contains' a word. Suggestion?
Apr 03 2023 10:22 AM
Sorry, I didn't catch why do you need conditional formatting to sum some cells with condition. You may use something like
=IF( <some cell> = "insurance", SUM(myRange), "")
Apr 19 2023 03:26 AM
@Sergei Baklan I hope you can help me, I have created a conditional rule eg. if A1 is higher in value than B1 it should highlight green but if its lower than it should highlight red, I know want to drag it down across the entire sheet but what's happening is that all formulas are based on the same B1 instead I need each row of A to compare to the same row in B (so A5 compares to B5), I have tried adding :$A$700 but that didn't work either - Please help
Apr 19 2023 04:18 AM
Make sure that the formula refers to B1, and not to $B$1 or B$1