conditional formatting
Hello,
I have a worksheet titled Sample on which cell B5 is the due date and cell B4 is the completion date. I want to use conditional formatting on a separate worksheet that displays a dashboard of the project in which a cell will fill red if the due date is today or has passed but the completion date is blank. I'm doing something wrong with the formula but cannot figure out what. Any help would be greatly appreciated.
=AND(TODAY()>=Sample!B5, Sample!B4=" ")
JBF9090 you need to use IF in
JBF9090 you need to use IF in conjunction with AND as follows:
=if(=AND(TODAY()>=Sample!$B5,Sample!$B4=""),1,0)
Then select Format & choose your colour from the fill Tab
Regards
Mark
Conditional formatting
Hello, I have a quick conditional formatting question.
This formula: =COUNTIFS(G1:K8,5,A1:E8,">=30") counts how many times a number greater than or equal to 30 from array A1 to E8 falls in the same position as the number 5 in array G6 TO K8. In the case below, the count will be 1 and happens for E2 and the matching 5 in K2.
In this particular case, I would like some help in creating a conditional formatting that would highlight all occurrences of the 5 in the column N.
I hope that this is clear enough. Any help will be greatly appreciated.
jddsoft I don't fully
jddsoft
I don't fully understand, do you mean you want blank cells in column N to be highlighted if there is a 5 in any of the cells between G & K for that row?
If so use the following in conditional formating starting in Cell N1
=if(countif(G1:K1,5)>=1,1,0)
then select format and choose a colour from the fill tab.
If you mean something else entirely please log as a separate case and attach an example
Regards
Mark