This isnt that directly useful for me.
Ive got a formula like this:=IF(OR(ISERROR(VLOOKUP($E234,'SHEET1.csv'!$A$1:$AZ$600,28,FALSE)),VLOOKUP($E234,'SHEET1.csv'!$A$1:$AZ$600,28,FALSE)=0),VLOOKUP($E234,'SHEET1.csv'!$A$1:$AZ$600,30),VLOOKUP($E234,'SHEET1.csv'!$A$1:$AZ$600,28,FALSE))
Basically saying put the 28th column cell value if the condition is matched, put the 30th column cell value if the condition is not matched.
I want to also have the values of the 30th column to be red or blue, so i could filter by them easily.
Basically what im asking is , i want the cells to be red (or blue) if the condition is not matched. Do you know a way (a forumula idealy) to do/apply this?
I could create anither column (helper column) to give me 1's or 0's and then i could easily spit/filter by that to see which rows my condition met or not, but ... it would be nice/cool to be able to put this in straight away by applying a make-colour forumula. (if it exists and if it is possible).
anyone?
Format Cells