cond format w/formulas

I am working on a spreadsheet, and I need to highlight blank cells prior to the text mark "AI." However, When I do this, it highlights the rest of the rows that are in that grouping where "AI" does not appear, and data has yet to be entered. I found this thread that got me part of the way there...

H Excellers, I have a formula based total in I3 In E3 I have a formula based total too. I need to conditional format the I3. Red if greater than or equal to 25% of E3, Amber 10% to 24% of E3, Green if 0% to 9%. I do not have the space to create a separate percentage column. Thank you in...

I have a spreadsheet that has a 7000 rows. My sheet does have a header row. Column G is not supposed to have any cell with a value greater then 1000. I want to highlight red the cells with these "bad values". This I accomplished with the conditional formatting cell value greater then 1000 and...

I have an excel file containing values from the Square of Nine and would like to add conditional formatting to include: 1. horizontal line at 180 degree angle 2. Vertical line at 90 degree angle 3. diagonal line at 45 degree angle Can you help formulate a formula that can be enabled as a...

Hello All, Thank you in advance for any and all your assistance. I am having difficulty figuring out how to highlight the surround cells of a cell containing text. I have a spreadsheet where an "X" is entered into various cells within a large range (ie. $C$3:$J$37). I would like to...

I currently have a workbook with two worksheets inside of it that has some of my clients names in both. Some matching, and some missing. I would like to use conditional formatting (or some other search method) to search "Sheet A" for names not found in "Sheet B" and highlight/format these names...

Hi everyone, I am trying to create a formula that will look at the value( a number) in C29 and if it is larger than the value ( a number) in C31 then fill C29 with red, if the value is less then fill C29 with orange. I believe this can be done with the if function along with some conditional...

Hello, In my spreadsheet in column F I have text which indicates that a line is to Renew Annually otherwise it's just equipment. If renewable then Column G is the Renewal Due Date (otherwise is just says "N/A") and Column H will be blank, or will indicate either “Done” for renewable lines that...