Hi,
I'm trying to do conditional formating based on the value of another cell. Currently I'm basing it on the first 5 characters in a different cell, as follows.
Forumula is: =left(b10,5)="73214"
Each cell in column b has 10 characters, the first 5 characters are consistent among groups (i.e. all things from group one are 73214*****, from group 2 are 96854*****, etc...)
My issue is that I want to highlight more than 3 groups (excel 03 allows only 3 conditional formatting functions) but with only three colors. For example I want to highlight the groups that start with 73214 and 54897 in yellow.
Is is possible to have a 'left' function that equals more than one thing??
Ex: Something like... =left(b10,5)="73214" OR "54897"
Or does anyone have any ideas of how else to go about this???
I hope I haven't gone into too much detail, please help if anyone knows the answer to this.
Thank you,
Giuseppe
Hi, i need to use conditional formatting function, but not with a defined cell.
The normal formula would be : =$E$5="C.O." then G5 would be highlighted as green.
But i need to use this down, and this would mean to insert a formula for all cells.
I need a formula that is looking two cells at the left of all cells and apply conditional formatting.
This is my table:
....E..........F..........G
...C.O................Green highlighting
...C.M.................Red highlighting
.....etc
I need a formula for all cells.
Can this be done?
Thanks!
Hi Fellow Excellers,
I'm trying to apply conditional formatting (shading) to cells that are left blank.
(Purpose: I am designing a research template for a client to complete with data and want the spreadsheet to show them where they've "missed a bit"!)
Does anyone know how to do this?
(When I go to the conditional formatting box, it asks me to specify when "cell value is"..."between/not between/equal to/not equal to" etc. But there's no option to specify when the cell is blank.)
Thank you!
Rach
I have a spreadsheet that has a couple columns. On the left is numbering and on the right side are properties. I have it setup so that if column B is blank, all the other columns are blank, including the numbering.
What i want to happen though is the blank cells shaded grey. So that if i add something it will come back white and so will the cells in the same row.
I know i have to use conditional formatting and i was thinking of writing something like:
Code:
=(B1="")
The problem i believe lies in the fact that the cells aren't blank, thay have formulas in them. so it doesn't work. even if i change it to =0 it still doesn't work.
any ideas?
Is it possible to use the 'or' function in conjunction with a conditional format.
I.e I need cells to be green if cell = x or y and red if cell = a or b.
I also need to be able to see the text (a,b,y or x)
Thanks
I am trying to colour a whole row of data (in columns A through to AA) based on the numeric entry in column AB. The numeric entry is either 1, 2 or 3. I reckoned I needed to use the IF function, but as writing formula is not my strong point I am struggling to enter the correct data! The first row of data I wish to use is 3. I have tried the following but to no avail: =IF($AB3,1). =IF($AB3=1). =IF($AB3="1"). Please tell me what I should be using
If column Y says "GTG" and column Z has a date in it, I want the cell(s) in column Y that say "GTG" to be red.
How can I put that into a formula for conditional formatting?
I'm trying to use the conditional formatting function for a formula which I've never done.
I'm tying to change the font of one cell to red if a different cell is equal to 0.00
But it's not working.
What formula do I put in that conditional formatting box to achieve these results
Hello all,
I'm trying to change the formatting of a cell by looking at the 2nd letter of a word mentioned in the cell next to it.
Example:
A1 = 1 B1= LA
So the conditional formatting-formula should be something like:
Code:
=IF(RIGHT(B1;1 )="A";)
But too bad, this didn't work.
Any suggestions?
Hi,
I'm trying to use the AND function in conditional formatting but I can't seems to get it to work.
I use the formula feature to do the following
=AND($A$2:$A$7="0",$B$2:$B$7="A") and if this is true, the cell on column B will be green. Attached is a sample. Can someone tell me if I had put it wrong? I can't get it to turn green.
I tried =AND($A$2:$A$7=0,$B$2:$B$7=A) but results is the same...
I'm using excel 2007.
