Conditional Formatting doesn't work until I select the item
OK, So I've got a report where each row contains a date. I want to be able to format the report so that if the status field is 'B' then it has red background, if its 'A' then has a green background, otherwise leave it as it is.
I've selected the conditional formatting option, and added the rules.
When I run the report, all the rows come out without the formatting *UNTIL* I click on the textbox with my data in, when the formatting appears.
Any ideas on how to get it to display the formatting all the time?
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
One way would be to create a colunn C and use the formula: =COUNTIF(B$2:B$200,A2) in cell C2. Then copy the formula down to C200. (assuming you have 200 entries in B...). This will put a "1" next to every number in Column A that has a match in column B. Then you could put a conditional formula in column A that will highlight the cell if the value in column C is equal to 1. Alternatively you could also simply filter for 1's in column C and then manually highlight the cells that show up in A!
option: formula is formula: =(datecell="") select formatting of choice
Highlight the order cells, go to >format>conditional formatting, choose "formula is" instead of "cell is". When you refer to the datecell, use the first date cell in the column only, and do not use $ signs.
in Excel 2007 and if you have a cell (say C2) with the value of elapsed time (for example set = A2 which contains start time plus B2 which contains end time - or current time) - click in the cell (C2) then on the Home tab click on Styles >> Conditional formatting choose Highlight Cells Rules>>Greater Than... set your value in the dialog to your respective value and choose your highlight. This is a start - you can then add new rules.
to then apply this same conditional formatting to every cell in that column Ctrl-C to copy the cell you just formatted - then click on the column header to highlght the entire column - Right-click and choose Paste Special - then choose Formatting for what to paste.
It's slightly different in Excel 2003 so let us know what version you are using.
Go down to the section about highlighting where there's an error. That's the basics of what you want to do. Now you need the code:
This will set a value of "True" if the string is -not- found inside. So if you want to flag it for finding the word NOT, you want the conditional formatting to kick in if the value of this is FALSE. =iserr(find("NOT",A1))