Excel formula based on cell color without vba 285582-Excel formula based on cell color without vba
Tip If you use >0 in the above formula, it means that the row will be colored no matter where the specified value or text is located in the key cell For example, the Delivery column (F) may contain the text "Urgent, Due in 6 Hours", and this row will be colored as wellIf you want to change the color of rows where the contents of the key cell starts with the indicated value or Hello, I am currently try to have cells change color according to their value I was wondering if there was a way to do this by using an "if" statement I am aware of conditional formatting, but I cannot copy and paste this formula so I would prefer to use an if statement For example, I have a value in "", and if "" is >= "B2" then it is green, if it is >="C2" andEnter new formula 'ColorCode' in cell D5 Now create = COUNTIF ($D$5$D$24,ColorCode) formula to count the number of color cells Create your custom formula to generate color code Co...